dfinke/ImportExcel

Using -Title switch results in -AutoFilter and -BoldTopRow switches not applying properly to the actual column header row which is now on line 2.

jeremytbrun opened this issue · 2 comments

jeremytbrun commented

$groupedUsers | Select-Object Name, Count | Export-Excel "<pathToXlsx>" -WorkSheetname "Agency Overview" -Title "Agency Overview" -TitleBold -AutoSize -AutoFilter -BoldTopRow

image

dfinke commented

If you want a quick fix, add the below after this line.

https://github.com/dfinke/ImportExcel/blob/master/Export-Excel.ps1#L272

    if($Title) {
        $startAddress="A2"
    }

This is not a complete fix and I'll need to do tests and it will be a bit before I can publish and update.

  • 👍1
y-master commented

I have the same issue with TableStyle, the table should start on line 2.
image