Excel Data Source

Applies to ReadyAPI 3.55, last modified on October 09, 2024

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.

In this topic, we focus on how to configure the Excel data source. We assume you are already familiar with data-driven testing and how to configure a data-driven loop. Otherwise, please read Basic Concepts of Data-Driven Testing, or complete some of our tutorials before you continue.

You can use Excel data sources in the Data Source 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
Data Source Loop Test Step
File Data Source
Grid Data Source
Data Source Types

Watch the video
 
Highlight search results