Add a TitleFillPattern and a PivotTable

[chpego]

I try to create a sheet in a file containing a table and a pivot table, as well as a title via the TitleFillPattern option; but as soon as I add this last line, the pivot table no longer works

$ExcelParams = @{
    Path          = $paaath
    PassThru      = $true
    AutoSize      = $true
    ClearSheet    = $true
    TableName     = "TableName1"
    Title            = (Get-Date -Format "dd/MM/yyyy")
    TitleFillPattern = "LightHorizontal"
    WorksheetName = "WorksheetName1"
}
$excel = $data | Export-Excel @ExcelParams

$pivotTableParams = @{
    PivotTableName  = "ListeUserADN"
    Address         = $excel."WorksheetName1".cells["F2"]
    SourceWorkSheet = $excel."WorksheetName1"
    SourceRange     = $excel."WorksheetName1".Tables."TableName1"
    PivotRows       = "Row1", "Row2", "Row3"
    PivotData       = @{"Row3" = "count" }
    PivotTableStyle = 'Light21'
    Activate        = $true
}

$pt = Add-PivotTable @pivotTableParams -PassThru
$pt.RowHeaderCaption = "Row1,Row2,Row3"

Close-ExcelPackage $excel

Any idea why the TitleFillPattern prevents the pivot table from working? it can no longer find the table reference

[dfinke]

No idea. AI search for that, and include EPPLUS in the prompt. My guess is it either not saving it correctly or there may be a workaround.