Beyond Export-Csv: Export-Xls
May 29th, 2010
61 comments
Warning: this post has no “virtual” content !
This time I post a function that allows you to export your data to a “real” spreadsheet (XLS format) instead of a CSV file.
The reason for posting this function was a series of threads in the PowerCLI Community by Suresh. Over several threads he has been collecting scripts that create various reports on his vSphere environment. Ultimately he wanted to have a spreadsheet where each report would be stored on a worksheet.
PowerShell has the very handy Export-Csv cmdlet to create CSV files but afaik nothing for creating XLS files 
