Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
danielodievich opened this issue Apr 11, 2016 · 0 comments
Labels

Comments

@danielodievich
Copy link

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.

@dfinke dfinke added the bug label Apr 11, 2016
dfinke added a commit that referenced this issue Oct 3, 2017
@dfinke dfinke closed this as completed Jun 23, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants