-Title takes over the table headers when used in conjunction with -TableName #89
Closed
Description
I have this code:
$comparisonResults | Select Name, Description, Type | Export-Excel -Path $excelResultsFilePath -WorksheetName "0-Summary" -TableName "t-0-Summary" -TableStyle Light1 -FreezeTopRow -AutoSize -Title "My Awesome Summary Title"
$comparisonResults | Select Name, Description, Type
Name Description Type
---- ----------- ----
1-Applications List of Compared Applications LISTOFAPPS
2-Configuration-Groups List of Unique Configuration Sections LISTOFGROUPS
The result is
My Awesome Summary Title | Column2 | Column3 |
---|---|---|
Name | Description | Type |
1-Applications | List of Compared Applications | LISTOFAPPS |
2-Configuration-Groups | List of Unique Configuration Sections | LISTOFGROUPS |
... And the filtering is set on the A1-A4, in "My Awesome Summary Title", instead of "Name", "Description" and "Type"
if I skip the -Title parameters, the table is property aligned to the "Name", "Description" and "Type" headers
I think if you have a Title property, you should start the table on the next row.