On the Select Excel Worksheet page, you can specify the name of an Excel worksheet. The current record of this worksheet will be stored to the DB table variable that you are adding to your test. The Select Excel Worksheet page contains the names of all the worksheets that exist in the Excel workbook specified on the previous page of the wizard.

The Select Excel Worksheet page is part of the wizards that assist you in adding DB Table variables to your test. These wizards are: Add Variable to Keyword Test and Add Variable.

To select a worksheet, click the needed name in the list. To preview the data of the selected table, press the View Sheet button to the right of the list.

Select the Treat the first row as column names option to specify whether the first row of the table will be recognized as a header.

After selecting the needed worksheet in the list, click Finish to store the data to the DB table variable. Back will return you to the previous page of the wizard. Cancel will close the wizard and abort adding the variable.

After adding the new DB table variable, you can use its value in other keyword test operations. For example, you can create data loops storing the current value of a database or a file to the DB table variable and using these values in cycles. To learn more about creating data loops in keyword tests, see the reference of the Data-Driven Loop operation.

Select Excel Worksheet Page (DB Table Variable Wizards)

See Also