ImportExcel

6.2.3

__tests__/PasswordProtection.tests.ps1

if ($PSVersionTable.PSVersion.Major -GT 5) {
     Write-Warning "Can't test passwords on V6 and later"
     return
}

Describe "Password Support" {
    Context "Password protected sheet" {
        BeforeAll  {
            $password = "YouMustRememberThis"
            $path = "$env:TEMP\Test.xlsx"
            Remove-Item $path -ErrorAction SilentlyContinue
            Get-Service | Select-Object -First 10 | Export-excel -password $password -Path $Path -DisplayPropertySet
        }
        it "Threw an error when the password was omitted " {
            {Open-ExcelPackage -Path $path }                     | should     throw
        }
        it "Was able to append when the password was included " {
            {Get-Service | Select-Object -First 10 |
                Export-excel -password $password -Path $Path -Append }  | should not throw
        }
        it "Kept the password on the file when it was saved " {
            {Import-Excel $Path }                                       | should     throw
        }
        it "Could read the file when the password was included " {
            (import-excel $path -Password $password).count              | should     be 20
        }
    }
}