ImportExcel/__tests__/Path.tests.ps1

Describe "Test reading relative paths" {
    BeforeAll {
        $script:xlfileName = "TestR.xlsx"
        If ([String]::IsNullOrEmpty($PWD)) { $PWD = $PSScriptRoot }
        @{data = 1 } | Export-Excel (Join-Path $PWD "TestR.xlsx")
    }

    AfterAll {
        Remove-Item (Join-Path $PWD "$($script:xlfileName)")
    }

    It "Should read local file".PadRight(90) {
        $actual = Import-Excel -Path ".\$($script:xlfileName)"
        $actual | Should -Not -Be $null
        $actual.Count | Should -Be 1
    }

    It "Should read with pwd".PadRight(90) {
        $actual = Import-Excel -Path (Join-Path $PWD  "$($script:xlfileName)")
        $actual | Should -Not -Be $null
    }

    It "Should read with just a file name and resolve to cwd".PadRight(90) {
        $actual = Import-Excel -Path "$($script:xlfileName)"
        $actual | Should -Not -Be $null
    }

    It "Should fail for not found".PadRight(90) {
        { Import-Excel -Path "ExcelFileDoesNotExist.xlsx" } | Should  -Throw "'ExcelFileDoesNotExist.xlsx' file not found"
    }

    It "Should fail for xls extension".PadRight(90) {
        { Import-Excel -Path "ExcelFileDoesNotExist.xls" } | Should  -Throw "Import-Excel does not support reading this extension type .xls"
    }

    It "Should fail for xlsxs extension".PadRight(90) {
        { Import-Excel -Path "ExcelFileDoesNotExist.xlsxs" } | Should  -Throw "Import-Excel does not support reading this extension type .xlsxs"
    }
}