Applies to ReadyAPI 2.8, last modified on August 16, 2019

The Excel data source obtains data from the Microsoft Excel file. It assigns data from the columns to the properties in the order they are listed in the editor. That is, the value of the first column will be assigned to the first property, the second column - to the second property, and so on.

Configuration

The Excel data source

Click the image to enlarge it.

File

Specifies the fully-qualified name of the desired Excel file. You can click Browse and select the desired file by using the Select file dialog.

Worksheet

The name of the worksheet’s tab containing data. By default, ReadyAPI gets data from the first sheet.

Start at Cell

Specifies the starting cell for data reading.

Ignore Empty

If selected, ReadyAPI ignores rows that do not contain data.

Evaluate formulas

If selected, ReadyAPI executes formulas in the document before obtaining data.

Note: You can use property expansions to insert values into the File, Worksheet and Start at Cell fields.

See Also

File Data Source
Grid Data Source
Data Source Types

Highlight search results