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