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.

Create new Excel file connector

Create new Excel file connector

To protect proprietary data like passwords you can mask specific columns of your data source.

Note Instead of using the default Excel file format xlsx for your test data you can also use the native binary file format xlsb. This file format is supported since Microsoft Office 2007 and is much faster than the non-binary version.