...
The presented workflow can be used to create a fully customized report based on exported measurements from InSpec that are processed in Microsoft Excel.
Setup Demo Project
Prerequisites:
InSpec Classic
Microsoft Excel Version 2211 or newer
Unpack ReportTemplate.zip files in C:\Users\Public\Documents
Make sure the files are located in C:\Users\Public\Documents\ReportTemplate
Copy the files to this directory if they are located in a subfolder like \ReportTemplate\ReportTemplate
Open ReportingTemplate.iwp in InSpec Classic
Start Playback and follow instructions
Observe how the custom report PDF is created
Close Programs without saving and delete ExportedResults.csv for repeated run
...
View file | ||
---|---|---|
|
Expand | ||
---|---|---|
| ||
Create Report TemplateCreate Report SheetCreate Data SheetImport CSV Data manuallyAdd References to Report SheetRecord Macro for CSV ImportRecord Macro for PDF ExportCreate VBS to Open Spreadsheet and Run MacrosCreate Batch file to run VBS |