Reference › Test Case Reference › Data Set Descriptions › Read Rows from Excel File Data Set

Read Rows from Excel File Data Set

The Read Rows from Excel File data set assigns values to properties based on the contents of an Excel spreadsheet.

The first nonblank row of the Excel spreadsheet specifies the names of the properties to which the data values are assigned. The subsequent rows list the data values to be used for these properties. The first full row of empty cells is treated as the end of data.

For example, you can test a set of first name, last name, user ID, and password combinations.

Complete the following fields:

Name

Enter the name of the data set.

Local

Designates whether the data set is global or local. Global is the default. Local data sets are created with one for each simulator. Global data sets are created once and shared by all simulators.

Random

Whether the record after the current record (sequential access) is read, or a random record is read. Sequential reading is the default.

Max Records to Fetch

The upper bound on the number of records to fetch for random access. This text field is disabled if the Random check box is not selected.

At End Of Data

Select the action for the end of the data set. You can start over, reading values from the start of the data set, or you can select the step to execute.

File Location

Enter the full path name of the Excel file, or browse to file with the browse button. You can use a property in the path name (for example, LISA_HOME).

Sheet Name

Enter the name of the sheet in the Excel spreadsheet.

Click the Test and Keep button to test and load the data. You get a message that confirms that the data set can be read, and shows the first set of data.

Select the steps that use the data set.

You can click the Open XLS File button to open and edit the Excel spreadsheet.

Note: Excel File data sets and Excel DTO data sets can use Excel 2007 or later spreadsheets. Excel DTO data sets are still created using the XLS format.