Skip to content
Zoan Docs

Win Extract Table

Win Extract Table

Section titled “Win Extract Table”

Type: win-extract-table  ·  Package: Desktop Activities v1.0.0  ·  Output: DataTable

Extracts data from a table or grid of a desktop application (.NET DataGrid, Java JTable, ListView…) and converts it into a DataTable. It is much more efficient than reading cell by cell: a single activity brings you the entire table, ready to process or dump into Excel.

How it works

Section titled “How it works”

Locate the grid by its selector and read its rows and columns. By default it includes the header row (includeHeader = true) and extracts up to maxRows rows.

Required parameters

Section titled “Required parameters”
ParameterEditorDescription
selectorselectorThe table or grid.

Optional parameters

Section titled “Optional parameters”
ParameterEditorDescription
sessionsessionWin Attach session. If omitted, the selector must include the window.
includeHeaderbooleanInclude the header row. By default true.
maxRowsnumberMaximum rows to extract. By default 500.
timeoutnumberMaximum in ms to wait. By default 30000.

Output

Section titled “Output”

Returns a DataTable with the rows and columns of the grid.

Example

Section titled “Example”
Win Extract Table   selector = (grilla "Movimientos")   → output: movimientos
Log   message = = "Filas extraídas: " + rowCount(movimientos)


For Each   items = = movimientos   itemVariable = fila
 └─ activities:
      Log   message = = str(row["Fecha"]) + " — " + str(row["Value"])
Section titled “Related activities”