Purpose

This example demonstrates how to use a Property Loader step type to load limits from a Microsoft Excel spreadsheet file. This example uses the LabWindows/CVI Adapter for Numeric Limit Test steps.

Example File Location

<TestStand Public>\Examples\Built-In Step Types\Property Loader Step Type\Property Loader - Loading Limits From Excel.seq

Highlighted Features

  • Property Loader steps
  • ReportOptions callback

Major API

None

Prerequisites

You must have Microsoft Excel installed.

How to Use This Example

The Property Loader step starts reading data from the START LIMITS marker and reads data until it encounters the END LIMITS marker.

Complete the following steps to review the sequence functionality.

  1. On the Steps pane, select the Property Loader step in the Setup step group.
  2. On Target File and Source Settings tab in the step settings pane, review the properties selected in the Property Tree control. The step loads the Limits.Low and Limits.High values for each step.
  3. On the Step Settings tab of the Steps pane, click the View File button in the sources table to open <TestStand Public>\Examples\Built-In Step Types\Property Loader Step Type\Limits.xls in Excel. The columns in the Excel file specify the properties to import, and the rows specify the names of the steps in the sequence.

Complete the following steps to run this example.

  1. Select Execute»Single Pass to run the sequence.
  2. When execution completes, review the report on the Report pane. The report indicates that TestStand updated the limits of the steps based on the values in the Excel file.
  3. In the Limits.xls file, change the Flow Rate value from 1 to 1.1 and save the file.
  4. Select Execute»Single Pass to run the sequence again.
  5. When execution completes, review the report on the Report pane. The report indicates that the results have changed because of the updated step limits.