Create a Customized Report using Microsoft Excel

Owned by Hanno Mueller
Last updated: Feb 09, 2023
2 min read

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

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

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

 

 

Product information is subject to change without prior notice as a result of ongoing technical development