Excel Data Source

Applies to ReadyAPI 3.10, last modified on September 23, 2021

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.

Tip: To learn how to set up a data source loop and refer to data source properties in your tests, see this topic.

You can use Excel data sources in the DataSource test step in functional tests, and in virtual services.

See the Excel Files as Data Sources tutorial to learn more about using the Excel data source in functional tests.

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.

When you select a file, ReadyAPI suggests importing property names from the file. If you agree, ReadyAPI will create data source properties using the data from the first row of the Excel file.

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

Basic Concepts of Data-Driven Testing
DataSource Loop Test Step
File Data Source
Grid Data Source
Data Source Types

Watch the video
 
Highlight search results