DataTable is a UFT object that acts as a wrapper to an MS Excel file, and its scope is global. This means that it can be accessed from any action within a test, as well as from function libraries that were attached to the test. When you create a new test or open an existing UFT test, you will notice that the DataTable pane will always show a global and local datasheet, one for each existing action within the test. In this section, we will see how to create a DataTable parameter.
Perform the following steps to create the DataTable parameter LocalParam1 for the local sheet:
From the File menu, navigate to New | Test or use the Ctrl + N shortcut. When a new test dialog opens, choose GUI Test and then click on the Create button.
We will create a DataTable parameter in the
Action1local sheet from the UFT data pane by double-clicking on the column header and entering the parameter nameLocalParam1in the dialog that opens, as shown in the following screenshot:
Similarly, for the test global sheet we will create a parameter named
GlobalParam1.Next, we need to enter our input data in the remaining cells of the parameter column in the global or local sheet, according to the requirements.
If we open the Default.xls file in the test folder (which, as its name suggests, is the default data source for a new test), we will notice that there are two worksheets, namely, Global and Action1. In each of these, the first row holds the name of the parameters, so we will see GlobalParam1 in the Global worksheet and LocalParam1 in the Action1 worksheet. You will also notice that the used rows have borders at the bottom of the worksheet (the borders have no real function; UFT identifies the used range by the number of used rows and columns based on the content range).