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.
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.
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.
If selected, ReadyAPI ignores rows that do not contain data.
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.|