이 내용은 고객님의 설정 언어로 확인할 수 없습니다

이 내용은 다른 사용 가능한 언어로 표시됩니다. 고객님께서 사용하시는 브라우저에 텍스트 번역에 도움이되는 기능이 포함되어 있을 수 있습니다.

Import Properties from Excel in TestStand using Property Loader Step

Updated Nov 30, 2022

Environment

Software

  • TestStand

TestStand consists of a Property Loader step that dynamically loads the property and variable values from a property loader source. Also, you may import and export data, such as limit values and preset variable values, to and from the Excel workbook (.xlsx) file as supported by Property Loader plugins.

In this tutorial, we will walk you through the steps on how to export and import the properties from an Excel workbook into TestStand by using the Property Loader step.

In order to create an Excel workbook with the correct syntax which you can read using a Property Loader step, you need to:
  1. Create the a Test Sequence and set the variables, properties.
  2. Run the Main Sequence ensuring that it passes Analyzing and Execution.
  3.  Import/Export Properties - Tools >> Import/Export Properties...                                                                                                                                                                                               
  4. This will open a Dialog Box. Ensure that you select Export on the left hand side. You can then go into the Property Selector tab to choose which variables from the sequence will be exported to the file.Edit the Export Options as required, then click Export to create the property file.

Note: The properties can also be stored as a .csv, .udl or .txt file if required.

  1. Then place a property loader step before your test sequence. As shown in the example. in step settings you can then point to this file and it will load in properties as specified in the file.

  2. You can navigate to the location specified in the Export Options window and edit properties in this file as required.
     

Additional Information

To dynamically create properties that are not currently in TestStand change the "When Property Not Present In Destination" to "Create"