Author Posts

November 20, 2017 at 9:46 am

I have taken health report of multiple servers and saves as webpage, since it has so much information. I want to convert into excel so that i can filter according to server name and check their stats. Can somebody help me how to do in powershell

November 20, 2017 at 10:50 am

I would recommend to get the health report in a format you need instead of converting an existing report.

November 20, 2017 at 11:40 am

The report has css included which makes it clear to read the data, that is the reason i made the report in html format.

November 20, 2017 at 12:01 pm

OK. But I think it will be harder than necessary to convert a html report instead of creating this report in csv and format the report inside Excel.

November 20, 2017 at 2:37 pm

I'll agree. There's nothing native in PowerShell that will magically do this; you're going to have to hand-code something to parse the HTML and output CSV. And the CSV will, of course, not include any CSS or formatting or anything. And coding for Excel is extremely difficult and tedious.