Extract Tables (Excel) Node

E

Data/Excel

Detects and extracts all tables from Excel worksheets, handling titles, multi-row headers, merged cells, footnotes and multiple tables per sheet

data_excel_extract_tablesdata

Inputs4

Outputs2

Security exposureUnrated

Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

No score metadata has been set for this node yet.

Input Pins

4

Input

Execution

exec_in

Trigger

File

Struct

file

Excel file

SchemaFlowPathFlowPathFlowPath3 fields

pathstringrequired

store_refstringrequired

cache_store_refstring | null

Schema enforced

Sheet

String

sheet

Worksheet name (optional - if empty, extracts from all sheets)

Extract Config

Struct

extract_config

Table detection configuration

SchemaExtractConfigExtractConfigExtractConfig10 fields

row_gap_toleranceinteger:uint

Blank rows tolerated inside one table (more consecutive blanks split tables)

format uintdefault 1min 0

col_gap_toleranceinteger:uint

Blank columns tolerated inside one table

format uintdefault 1min 0

min_table_rowsinteger:uint

Minimum data rows for a region to count as a table

format uintdefault 2min 0

min_table_cellsinteger:uint

Minimum non-empty cells for a region to count as a table

format uintdefault 4min 0

min_densitynumber:float

Minimum non-empty density (0.0–1.0) of a region's bounding box

format floatdefault 0.10000000149011612

max_header_rowsinteger:uint

Maximum header rows to detect and flatten

format uintdefault 3min 0

header_joinerstring

Joiner when flattening multi-row headers

default " / "

drop_aggregate_rowsboolean

Drop subtotal/total/aggregate rows from the data

default true

use_defined_tablesboolean

Use Excel defined tables (ListObjects) as authoritative when present

default true

adaptive_segmentationboolean

Try several gap-tolerance segmentations and keep the best-scoring one

default true

Default {"row_gap_tolerance":1,"col_gap_tolerance":1,"min_table_rows":2,"min_table_cells":4,"mi...

Schema enforced

Output Pins

2

Output

Execution

exec_out

Next

Tables

Struct Array

tables

Extracted tables (name, title, A1 range and typed rows)

SchemaCSVTableCSVTableCSVTable6 fields

namestring | null

Optional name/identifier for this table

titlestring | null

Optional title text found above the table in the source sheet

rangestring | null

Optional A1 range the table was extracted from (e.g. "A3:F42")

headersArray<string>required

itemsstringarray item

rowsArray<Array<Cell>>required

itemsArray<Cell>array item

itemsCellarray item

variant 1nullvariant

variant 2booleanvariant

variant 3integer:int64variant

format int64

variant 4number:doublevariant

format double

variant 5stringvariant

+1 more fields

sourceanyOf (2)

variant 1FlowPathvariant

pathstringrequired

store_refstringrequired

cache_store_refstring | null

variant 2nullvariant

Node Info

Internal name

data_excel_extract_tables

Category

Data/Excel

Version

2