Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Import-Module dbatools;
Import-Module ExcelPSLib;
$credential = Get-Credential;
# get results from table
$result= Invoke-DbaQuery -SQLInstance localhost -Database master -Query "SELECT * FROM sys.tables" -SqlCredential $credential ;
# debug the output
$result | Out-GridView;
$begin = Get-Date;
# export to excel
$result | Export-OOXML -FileFullPath test.xlsx -WorksheetName test -AutoFit -HeaderStyle WhiteSmoke;
$end = Get-Date;
echo "duration $($end-$begin)"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment