Switch -ClearSheet when exporting Excel with PivotRows

[ArtieLadie]

Tested out code at zPSExcel.Intro.ps1 and added -ClearSheet after every Export-XLSX command.

However, when adding -ClearSheet after

Export-XLSX -Path C:\Temp\Files.xlsx -PivotRows Extension -PivotValues Length -ChartType Pie -ClearSheet

Following errors output:

Add-PivotTable : Skipping existing worksheet 'PivotTable1'
At C:\Windows\system32\WindowsPowerShell\v1.0\Modules\PSExcel\Export-XLSX.ps1:359 char:26

•             $Excel = Add-PivotTable @Params -Excel $Excel -WorkSheetName $Wo ...
  

•                      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
  • FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Add-PivotTable

You cannot call a method on a null-valued expression.
At C:\Windows\system32\WindowsPowerShell\v1.0\Modules\PSExcel\Export-XLSX.ps1:374 char:17

•             $Excel.SaveAs($Path)
  

•             ~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : InvalidOperation: (:) [], RuntimeException
  • FullyQualifiedErrorId : InvokeMethodOnNull