19 January,2012 by Jack Vamvas
SQL Server, Powershell and Excel are a good mix . But saving to Powershell output to HTML is versatile – if requiring email attachments or publishing results to a web page .
Any Powershell scripts using Excel as an end point can be converted to HTML with just a few lines of code. Therefore you can keep the Powershell \ Excel code , and add some lines for HTML output.
The convert process , creates well formatted HTML pages , ideal for reports. Creating the reports in HTML makes them easier to read on my smartphone – which does a better job at web browsing rather than reading Excel
$xlHtml = 44 $omit = [type]::Missing $Excel = New-Object -ComObject Excel.Application --some activity e.g recordsets --would normally save Excel as : --$EXcel.ActiveWorkbook.SaveAs("c:myfile.xls") --instead save the workbook as html $EXcel.ActiveWorkbook.SaveAs("c:myfile.html",$xlHtml,$omit,$omit,$omit,$omit,$omit,$omit,$omit,$omit,$omit,$omit) $Excel.Quit()