Test Studio allows you to use external data files for data driven testing. In this article you can read how to associate a test to an external data source.
If you have already related the external data source to a test in the project, follow this link to go through a complete scenario for data driven test with external data source.
Once you have added a data source definition to your test project, you are ready to bind your test to that data source.
Choose a test from the Project Explorer and click the Bind Test button from the Data Source section in the Project ribbon.
The Bind test to data source dialog opens with the option to choose a data source. Click the Select Data Source drop-down and select the one you have defined. If your source is an Excel spreadsheet, choose which sheet from the spreadsheet to use. Once you select a sheet, the data from that sheet will be read and displayed in the dialog. Check out that the first row of the spreadsheet is used to define the column names.
|Choose Data Source to Bind||Excel Sheet Selected|