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.

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



Maximum worksheet size

1,048,576 rows by 16,384 columns

Maximum number of worksheets

Limited by available memory

Column width

255 characters

Text length

32,767 characters

Formula length

8,192 characters

Number precision

15 digits

Largest positive number


Smallest positive number


Largest negative number


Smallest negative number


Maximum number of names per workbook

Limited by available memory

Maximum length of name


Maximum length of format string


Maximum number of tables (workbooks)

Limited by system resources (windows and memory)

Back to top

See also: