Excel File

The last type of data connector is the Excel file connector. This connector allows you to use an Excel file to provide data for your test suite. After adding an Excel file connector, the data source management dialog will be opened.

You can edit the name of the data connector in the text box marked red and choose the Excel file by selecting a file in the green marked area. By checking or un-checking the check box marked blue you can decide either to include or to exclude the selected Excel file to your test suite. By checking this check box, a copy of the file will be placed in your solutions folder. Additionally you can define the worksheet and the range of the worksheet which will provide the data for the Excel file connector in the yellow marked area.