Starting Situation
- Instead of having the plain old text in Report files, users can automatically design the Excel reports by using the Import Excel Module.
- Users can organize all the data in rows and columns, with the selective choice of colors, PivotTable, and Charts can design the sheet for better visualization. PowerShell Excel module lets you create Excel pivot tables and charts from the raw data.
Use Cases
The PowerShell CLI is used by jobs to create reports. Two modules are applied for this purpose:
- the JobScheduler PowerShell Module
- a reporting PowerShell Module. This example makes use of the ImportExcel PowerShell Module that can be used to create Excel® reports on Windows and Linux.
Find a sample report: jobscheduler_designed_report.xlsx