PSWriteHTML VS ImportExcel

There are some cool PowerShell HTML modules, run Install-Module PSWriteHtml and go to town. Check our their list of articles (just scroll down a little in the ReadMe) for a really easy way to get started: https://github.com/EvotecIT/PSWriteHTML

Import-module Import-Module PSWriteHTML Gathering Data $results = [pscustomobject] @{ 'Source DC' = "Myserv.HostName.ToUpper()" 'Partner DC' = "N/A" Direction = "N/A" Type = "N/A" 'Last Attempt' = "N/A" 'Last Success' = "N/A" 'Last Result' = "1" } # Prepare to export in a beautiful HTML file $ReportPath = "$PSScriptRoot\DHCPReport-At-$(Get-Date -f "dd-MM-yyyy").html" # Optional settings : set default values for some cmdlets (I'm lazy) $PSDefaultParameterValues = @{ "New-HTMLSection:HeaderBackGroundColor" = "Green" "New-HTMLSection:CanCollapse" = $true } New-HTML -FilePath $ReportPath -Online -ShowHTML { # First Tab New-HTMLTab -Name 'DC Health Report' { New-HTMLSection -HeaderText "Replication Status" { # Here, we're putting all Data previously gathered in the var $Result New-HTMLTable -DataTable $results { New-TableCondition -Name "Last Result" -Operator ne -Value "N/A" -BackgroundColor red -Color white -Alignment center New-TableContent -Alignment center } #end-newHtmlTable } # end New-htmlSection # In the same Tab, you could add another section (of course in my case, this section is empty New-HTMLSection -HeaderText "Replication Status2" { # Here, we're putting all Data previously gathered in the var $Result2 New-HTMLTable -DataTable $results2 { New-TableCondition -Name "Last Result" -Operator ne -Value "N/A" -BackgroundColor red -Color white -Alignment center New-TableContent -Alignment center } #end-newHtmlTable } # end New-htmlSection } # end New-HtmlTab # But you could add some other tabs New-HTMLTab -Name 'DC Health Report2' { New-HTMLText -FontSize 16 -Color blue -Text @( "This is a text with a lion to [PSWriteHTML Github site](https://github.com/EvotecIT/PSWriteHTML)." "This is not really difficult" ) } # end New-HtmlTab } # end-New-html

Have you consider to use the wonderful PS module called PSWriteHtml (available also on PSGallery of course) ?

To build on this there is a nice powershell module for HTML noobs called PSWriteHTML

Examples here that are similar to what you are trying to accomplish - https://github.com/dfinke/ImportExcel

Did you visit the GitHub repo and read the docs & examples? https://github.com/dfinke/ImportExcel

If you can create a reproducible example with sample data and code that re-creates the issue from nothing, post it to the project's issues on Github. The module's authors have been very quick to resolve the issues I've had, usually fixing the problem in a week or two.

If you're using scripting, I have to recommend ImportExcel for Powershell.

You might be able to use https://github.com/dfinke/ImportExcel to alter single cells in a csv file but I'm not 100% sure.

Have you looked at the examples? Examples

Maybe look at ImportExcel, it allows to put any list of objects right into Excel sheets, with insane customization capabilities.