Parameterized cell values in the Input data sheet

When working in tests, after you record an Input statement to create an input data sheet, you can modify the values to be used in the run session, and you can create multiple sets of table or grid cell data to be used in different iterations of an action.

As described above, when you record the Input statement, UFT records the values you set in the appropriate rows and columns in the input data sheet for that table or grid. Below the data it adds an end row (shaded in blue) with the text .END in the first cell of the row. This row indicates the end of the first set of data for the table or grid. This set of data and its corresponding end row represents a single data set.

UFT inserts an Input statement and a new input data sheet each time information including modified table or grid cell data is sent to the server. If you set data in the cells of a particular table or grid both before and after sending information to the server, you will have more than one input data sheet (and more than one Input statement) representing the same table or grid. For best results:

  • Enter data only in the visible rows of the table or grid while recording, especially if scrolling results in sending information to the server. You can add additional rows to the recorded data set while editing your test.

  • Perform sorting, calculations, and other such operations either before beginning or after you finish entering data in a table or grid.

To supply different data values for each action iteration, you add new data sets. You add a new data set for a table or grid by entering the values in the appropriate rows and columns below the previous end row. To indicate the end of the new data set, copy and paste the end row from the first set of data to the row below the new set of data. You can include a different number of rows in each data set.

Note: The Input statement can run successfully only if it can find the end row. Therefore, the first cell of the end row must contain only the text .END. You can enter text into other cells in that row, if needed. For example, you can enter a number in the second cell of the end row to indicate the iteration number corresponding to that set of data.

Because the input data sheets are added as a sub-sheet of the current action, the Input statement uses the data set corresponding to the current action iteration. For example, if you set the action to run on all iterations and your action sheet includes five rows of data, then your input data sheet should also include five data sets (and five .END rows).

To use multiple sets of data from an input data sheet, you must have at least one other Data pane parameter in your action that is set to use Current action sheet (local). Also, confirm that the action is set to run multiple iterations in the Run Tab (Action Call Properties Dialog Box).

Example: The input data sheet below contains three sets of data. The first set contains data for the top three rows of the table or grid. The second set contains data for the top two rows of the table or grid. The third set contains data for rows 2-5. The blank first row (row 8 in the data sheet), indicates that no data should be entered or modified in the first row of the table or grid.

Note that a number was manually entered into the second cell of each END row to make it easier to identify the action iteration to which each data set corresponds.