Extra Columns in HTML Output From SQLcmd


I’m getting extra columns when trying to output an SQL query to HTML. I get RowError, RowState, Table, ItemArray & HasErrors along with with my actual query results. These looks like property values attached to the object created by Invoke-Sqlcmd.

PS C:\> $myTable | ConvertTo-Html -as TABLE | Out-File C:\Test.htm PS C:\> Invoke-Expression C:\Test.htm

Any ideas how I can strip those out?


By default, ConvertTo-HTML converts ALL properties you give it into columns. Just use its -Prop parameter to specify the properties you want.

Ahh, so simple…

Thank you very much!


In case you use it elsewhere, just an FYI: Invoke-Expression is a bit risky, and can expose you to code injection.

Invoke-Item would work in this example.