Versions Compared

Version Old Version 1 New Version Current
Changes made by

Hanno Mueller

Hanno Mueller

Saved on

Key

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

...

Info

This article presents an application example and uses third party software.

For questions regarding third party software, contact the corresponding company.

This example uses Microsoft® Excel® Version 2211 Build 16.0.15831.20220

...

Microsoft Excel The presented workflow can be used to create a fully customized report based on a CSV file containing measurement results.exported measurements from InSpec that are processed in Microsoft Excel.

Image Added

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