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:
Action1
local sheet from the UFT data pane by double-clicking on the column header and entering the parameter name LocalParam1
in the dialog that opens, as shown in the following screenshot:Similarly, for the test global sheet we will create a parameter named GlobalParam1
.
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).