Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

  1. Unpack ReportTemplate.zip files in C:\Users\Public\Documents

  2. Make sure the files are located in C:\Users\Public\Documents\ReportTemplate

    1. Copy the files to this directory if they are located in a subfolder like \ReportTemplate\ReportTemplate

  3. Open ReportingTemplate.iwp in InSpec Classic

  4. Start Playback and follow instructions

  5. Observe how the custom report PDF is created

  6. Close Programs without saving and delete ExportedResults.csv for repeated run

...

View file
nameReportTemplate.zip

Expand
titleCustomize Report Template

Create Report Template

Create Report Sheet

Create Data Sheet

Import CSV Data manually

Add References to Report Sheet

Record Macro for CSV Import

Record Macro for PDF Export

Create VBS to Open Spreadsheet and Run Macros

Create Batch file to run VBS