__tests__/PasswordProtection.ps1

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  
        }
    }
}