The most simple way of creating Excel reports requires just a couple of lines of PowerShell code: dump the results to a CSV file, then submit it as an argument to Excel:
#requires -Version 2.0
$timestamp = Get-Date -Format 'yyyy-MM-dd HH-mm-ss'
$Path = "$env:temp\Excel Report $timestamp.csv"
Export-Csv -Path $Path -Encoding UTF8 -UseCulture -NoTypeInformation
Start-Process -FilePath excel -ArgumentList """$Path"""
There are a couple of things to watch out for:
ReTweet this Tip!
Powered by IDERA