Skip to content

-Title takes over the table headers when used in conjunction with -TableName #89

Closed
@danielodievich

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.

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions