Relevant for: API testing only
This dialog box enables you to add a new Excel data source to the Data pane or change the underlying file for existing Excel data sources.
Before you open the dialog boxes, make sure that an API test or component is in focus in the document pane.
When entering values into the Excel sheet, you should use the Excel General format for values.
User interface elements are described below:
|Data source name||
A name for the data source as it will appear in the Data pane. If no value is specified, it uses the file name.
Note: This field is read-only in the Change Excel Data Source dialog box.
|Excel file path||
The complete path of an Excel file on the file system. Use the Browse button to locate the file.
Note: You must use an absolute path for the Excel file path.
|Excel file contains header row||
Indicates whether the data in the Excel table contains a header row. Header rows are ignored when running the test.
The location for storing the imported Excel data:
|Allow other tools to override the data||
Enables you to overwrite data from the imported Excel file with values from other tools, such as an ALM Data Resource (for versions ALM 11.00 and higher), and GUI or API tests.
For details about ALM data resources, see Test parameterization and test configurations.
Tip: If you did not enable this option when you imported the Excel file, you can enable it separately for each data source in the Properties pane. For details, see Data Source Properties Tab (Properties Pane - API Testing).