SQL Results to Powershell HTML Document

Question

I have a SQL record set that I pulled from our internal project management software that has HTML tags in it. I would like to take this record set and create a HTML document with Powershell that follows the format of the tags. Is it possible to do this?

I tried this code:

$VersionNotes = Invoke-Sqlcmd -ServerInstance $svr -Database $database -Query $versionSQL 

$VersionNotes | Select-Object Name, ReleaseNotes | ConvertTo-Html |  Out-File c:\temp\htmltest.htm
Invoke-Expression C:\Temp\htmltest.htm

But it just returns the SQL results unformated.

frank · Accepted Answer · 2017-05-24 02:27:48Z

1

Try with this ..

$VersionNotes = Invoke-Sqlcmd -ServerInstance $svr -Database $database -Query $versionSQL 

$Html = $VersionNotes | Select-Object Name, ReleaseNotes | ConvertTo-Html | Out-String 
[System.Reflection.Assembly]::LoadWithPartialName("System.web") | Out-Null
$Html = [System.Web.Httputility]::HtmlDecode($Html)

ConvertTo-HTML  -PostContent $Html | Out-File C:\Temp\htmltest.htm
Invoke-Expression C:\Temp\htmltest.htm

More details How to make SQL results to HTML document using PowerShell

edited May 24, 2017 at 2:27

answered May 19, 2017 at 9:00

frank

1262 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Results to Powershell HTML Document

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related