Table of Contents
...
| Field Name | Description |
|---|---|
| Excel Workbook Information Section | |
| Excel file path | Path and name of the Excel file to use when importing parameter values |
| Named range | Name of the Excel region where parameters are located in the Excel file. See the section on the named region to define these region names. Syntax example: MyTable |
| Sheet name and range | Excel range where parameters are located in the Excel file. The range must include the name of the sheet and all heading cells. Syntax example: Sheet1!A1:G15 See section on Excel range to define a sheet name and range. |
| Import from Excel | By clicking this button, TestView reads the Excel file and imports the parameters from the file |
| Auto import data on play | When this option is checked, TestView automatically imports Excel data at the beginning of the test sequence |
| PARAMETERS SECTION | |
| Category | Category of the component to select to add new parameters |
| Component | Component to add to the list |
| Parameter | Parameter to add to the list |
| LIST SECTION | |
| New | Add a new subset to the list of subsets. The new subset uses the component and parameter defined in the parameter section |
| Subset item | List of subset items used by TestView while iterating the loop |
| SUBSET SECTION | |
| Index | Iteration number |
| Component name | Component that changes during the iteration |
| Parameter name | Parameter for which the value will change during the iteration |
| Value | New value for the iteration |
| Add | Add a new iteration to the list |
| Remove | Remove and iteration from the list |
Excel Test Definition
The Excel Worksheet allows users to define parameters for power system components. These parameters are used by the TestView auto loop step.
...