Data Pane

Relevant for: GUI testing, API testing, and business process testing

UFT One enables you to insert and run steps that are driven by data, including mathematical formulas, in the Data pane.

In this topic:

Data table content

Enter data top to bottom and left to right, leaving no gaps of entire rows or columns.

Very large numbers in the data table may cause unexpected behavior.

UFT One does not support colors, formatting, and special cell formats.

Back to top

Data table values

Values returned from the data table are always converted to strings. Use VBScript conversion functions to convert values to other types.

For example:

Window("Flight Reservation").WinComboBox("Fly From:").Select CInt(DataTable("ItemNumber", dtGlobalSheet))

Back to top

Changing parameter names in a data table

If you change a data parameter name in the first row of the data table, also update the relevant name of the parameter wherever else it is used, such as checkpoint or output values, or any ALM parameter mappings.

Back to top

Importing Excel files to the Data Pane

Excel files may be incompatible with UFT One if they contain features or functionality unavailable for GUI tests. Remove the incompatible functionality and try again.

Special formatting in Excel files are not imported, and data is displayed in the Data pane with fixed values.

UFT One does not support cross references to other Excel sheets.

For details on supported versions of Microsoft Excel, see the UFT One Support Matrix.

Back to top

Data Pane Specifications

Back to top

See also:

• Data Pane (GUI Testing)
• Data Pane (API Testing)
• Data Pane (BPT in UFT One)
• Test parameterization and configurations
• Data drive a test in ALM
• Use different data tables
• Formulas in data tables
• Naming conventions