has the ability to colour code cells.
# # $finalrepinfo is array # $html = $finalRepInfo|ConvertTo-Html -Fragment $xml = [xml]$html $attr = $xml.CreateAttribute("id") $attr.Value='diskTbl' $xml.table.Attributes.Append($attr) $rows=$xml.table.selectNodes('//tr') for($i=1;$i -lt $rows.count; $i++){ $value=$rows.Item($i).LastChild.'#text' if($value -ne $null){ $attr=$xml.CreateAttribute('style') $attr.Value='background-color: red;' [void]$rows.Item($i).Attributes.Append($attr) } else { $value $attr=$xml.CreateAttribute('style') $attr.Value='background-color: green;' [void]$rows.Item($i).Attributes.Append($attr) } } #embed a CSS stylesheet in the html header $html=$xml.OuterXml|Out-String $style='<style type=text/css>#diskTbl { background-color: white; } td, th { border:1px solid black; border-collapse:collapse; } th { color:white; background-color:black; } table, tr, td, th { padding: 2px; margin: 0px } table { margin-left:50px; }</style>' ConvertTo-Html -head $style -body $html -Title "Replication Report"|Out-File ReplicationReport.htm
No comments:
Post a Comment