search

VladDBA / PSBlitz

a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files.
Other
69 stars 17 forks source link

Export to Excel using PS module ImportExcel? #170

Open martin-guth opened 6 months ago

martin-guth commented 6 months ago

Hi @VladDBA,

this project sounds promising...I will give it a shot. You write that export to Excel is possible only when Excel is installed on the system. Have you considered to use the module ImportExcel. I have a blog post on it how to get started: http://www.martinguth.de/reporting/exporting-to-excel-from-powershell-without-having-excel-installed/

Cheers

Martin

VladDBA commented 6 months ago

Hi @martin-guth,

Thank you for the feedback! I did consider the ImportExcel module as an option at the beginning. The issue is that some Orgs might have stricter security policies than others, strict enough to not allow for additional modules to be installed via PS. But most Orgs do use the Microsoft Office suite, and, for the rare cases where that's not viable, there's the option to export to HTML just like Oracle's AWR reports.

I'll look into it a bit more, maybe I can use it as self-contained resource and not require it to be installed separately