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.
I have this code:
The result is
... 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.