xlsx file is created and Excel is launched with your results. The table style names you can find out by recording a macro, applying the formatting by hand, and then reading off of the VBA module what style name Excel filled in once you've stopped the recording. So you’ve exported some information to a file called processes. Of course, the commands I’ve used here are pretty useless in this format, but the concept of being able to run complex PowerShell commands side-by-side on multiple sheets in one workbook was a cool idea to me, and can potentially be very powerful. Here’s Get-Process, Get-Service and a directory listing all in one Excel spreadsheet format as a report, plus, it is interactive.
“OK, get information about services and pipe the results to a table.
Powershell excel format as table Regards, Yoshihiro Kawabata.
