Set the First Row as Header in PowerShell Com-Object

Question

I'm following this post here: https://social.technet.microsoft.com/forums/lync/en-US/acf022bf-5d9c-4d3d-b9ca-2d8a368ca786/insert-a-table-in-excel-using-powershell?forum=ITCG

It Creates a table on my Worksheet and no errors, but how can I set my First Row (Which is now the Row 2 of my Output File) as the Header of my table?
And what does $Null do here in this line?
$ListObject = $OutputSheet.ListObjects.Add([Microsoft.Office.Interop.Excel.XlListObjectSourceType]::xlSrcRange, $OutputSheet.UsedRange, $Null)

Thank you :)

Answer 1

https://learn.microsoft.com/en-us/office/vba/api/excel.listobjects.add

It looks like $null is to external data source, but is not relevant.

Indicates whether an external data source is to be linked to the ListObject object. If SourceType is xlSrcExternal, the default is True. Invalid if SourceType is xlSrcRange, and will return an error if not omitted.

Also note that the post you reference has a better answer that does not generate a new line

$ListObject = $ExcelApplication.ActiveSheet.ListObjects.Add([Microsoft.Office.Interop.Excel.XlListObjectSourceType]::xlSrcRange, $ExcelApplication.ActiveCell.CurrentRegion, $null ,[Microsoft.Office.Interop.Excel.XlYesNoGuess]::xlYes)