Hello Powershell gurus
I am using powershell to create an excel worksheet and work wiith it. I will need to make report, which has a table and I require formatting the column headers etc. I have researched on internet, specifically the article : PowerShell and Excel: Adding Some Formatting To Your Report
The problem with this is that border creation seems to be a very cumbersome process. While the powershell team has created out-html to print out reports very efficiently and conviniently, is the data output to excel been taken care of in powershell v5, or in any version?
I would prefer a way to easily create a visually appealing table in an excel spreadsheet.
Please share the code if possible.