GUI: Get Table Data

Description

Get Table Data retrieves data from Windows desktop elements of type List, Grid, Table, or Data Grid, filtered by the criteria you provide. Use this step when your workflow needs to extract structured data from a desktop application — for example, reading rows from an order list, pulling values from a configuration grid, or capturing records from a data table. You can choose to get the entire table with specific columns, a single row with specific columns, or a single cell by specifying row and column indices. The step uses Windows Spy to identify the target table element and stores the extracted values in output variables.

Configurations

Field Name	Description
Step Name	Name of the step. The name must be unique in a single workflow.
Action Type	Select the type of action you want to perform from one of the following:-Entire Table With Specific Columns-One Row With Specific Columns-One Cell
Window Path	Window Path is the relative path of the desktop application on which element exists. It is captured by GUI Spy in the Generate Step dialog. It is then populated in the step configuration upon Step Generation. You may also enter or modify Windows path manually on the ‘Step Generation’ window or step configuration. Windows path may be provided as a String or regex. Sample of Windows Path as string: w[Desktop]/w[Application Name] or Sample of Windows Path as regex: w[Desktop]/w[/Application N/], w[Desktop]/w[/Application .*/],If you are putting partial application name then put ii as a regex between / and /. Also if the Application name changes dynamically it is a good idea to provide it as a regex.
Criteria	‘Criteria’ is the criterion to locate element on Windows Desktop. It is captured by Windows Spy in the Generate Step dialog. Upon Step Generation it is populated in the step configuration. You may change criteria by choosing from the list in ‘Step Generation’ window or step configuration.Note: It is similar as in GUI Automation plugin steps.
Criteria Value	Specify relevant criteria value for the criteria provided above.
Element index (Starts with 0)	For Multiple elements with same criteria, specify index of the element you want to locate. Provide index 0 if you want first element from the located elements, increment index by 1 for the next elements.
Row Index	Specify the Row Index to fetch data.Note: Row index is enabled only if one of the following is chosen in Action Type:- One Row With Specific Columns - One Cell
Get Values (Tabular):
Column Index	Specify the Column Indices to fetch data.
Output Variable	Specify an output field to hold the value of Step execution.
Timeout (In seconds)	Specify a Timeout to find the element on the Desktop application.

Field Name

Description

Button: Edit Element

Click Edit Element to start spying. Opening spy from step is restricted to the step, that is, only relevant elements are detected from active spy. Use Hotkeys (‘Shift’ or ’~’) to detect the element. We may call it as a ‘Step Restricted Spy’ for understanding purposes.For example, suppose spy is started from ‘Get Table Data’ step. Now spy is restricted to elements of type ‘Table’ only. All element of type ‘Table’ will be highlighted in blue color. If we try to detect element other than of type ‘Table’ it will be highlighted in ‘Red’ color upon hover. Step dropdown is disabled and value selected is ‘Get Table Data’.