| 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