ImportExcel

7.2.2

Examples/InteractWithOtherModules/Pester/Analyze_that.ps1

                                param(

    $PesterTestsPath = "$PSScriptRoot\..\..\..\__tests__\"

)

$xlfile = "$env:Temp\testResults.xlsx"

Remove-Item $xlfile -ErrorAction SilentlyContinue

$xlparams = @{

    Path              = $xlfile

    InputObject       = (Invoke-Pester -Script $PesterTestsPath -PassThru).TestResult | Sort-Object describe

    WorksheetName     = 'FullResults'

    IncludePivotTable = $true

    PivotRows         = 'Describe'

    PivotColumns      = 'Passed'

    PivotData         = @{'Passed' = 'Count' }

    IncludePivotChart = $true

    ChartType         = 'BarClustered'

    AutoSize          = $true

    AutoFilter        = $true

    Activate          = $true

}

Export-Excel -Show @xlparams