cisagov / ScubaGear

Automation to assess the state of your M365 tenant against CISA's baselines

https://www.cisa.gov/resources-tools/services/secure-cloud-business-applications-scuba-project

Creative Commons Zero v1.0 Universal

1.6k stars 217 forks source link

Output to .xlsx instead of .csv #1355

Open buidav opened 5 hours ago

buidav commented 5 hours ago

💡 Summary

This issue to explore and implement outputting to .xlsx instead of .csv. Switching to .xlsx allows for additional features to be added to the spreadsheet outputs. Such as multiple tabs, graphs, filters etc.

Motivation and context

To provide more flexibility of output options

Implementation notes

Requires an additional PowerShell module to be included as a dependency ImportExcel
Refactor current .csv code in Orchestrator.psm1 to use Export-Excel

Acceptance criteria

ScubaGear outputs to .xlsx instead of .csv for all spreadsheet output
- ScubaResults.csv => ScubaResults.xlsx
- ActionPlan.csv => ScubaResults.xlsx (separate tab)

schrolla commented 3 hours ago

The only point I would add is that the value of CSV is that many tools support it, leaving that up to the user. So rather than replacing CSV support, you might instead add it as a -ResultFormat option that supports both. I'd also make sure that the xlsx results are readable by other programs that support that format (e.g., Google Sheets, OpenOffice, LibreOffice) so as not to pin manipulation of results to one program.