When adding an external data file to your project, a copy of that file is placed in the Data folder under the project's root folder. This is from where the file is accessed and any changes should be made to the file in this location.
The first row entries in the Excel spreadsheet are used as column names when attaching columns to the inputs. In this example, Input A is the name of the first column, Input B is the name of the second column, and Results is the name of the third column and these will be used to identify the columns to attach to the input values of the test steps.
Note!_ For numeric-only fields, you may need to add an apostrophe, also known as a single quote character ( ' ), to the beginning of the number for the data to render correctly in Test Studio. This is an Excel command to store the number as text.
Open the data source dropdown by clicking its button down arrow, then select Add New > Excel.
The Create new data source dialog opens:
Enter the path to your Excel file or click the "..." button to browse and select it. Click Create to save this data source definition. A new entry is added to the Data folder of your test project.
Click Ok to confirm binding the current test to the Excel data file.
Then select data source and data table in the Bind test to data source dialog to see the Excel sheet data bound to the test.