Extract Tables (Excel) Node

E

Data/Excel

Extract Tables (Excel)

Extracts tables from an Excel worksheet

data_excel_extract_tablesdata

Inputs4

Outputs2

Security exposure10/10

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

Extract Config

SchemaExtractConfigExtractConfigExtractConfig29 fields

delimiterinteger:uint8required

CSV delimiter (`,` or `;` typical)

format uint8min 0max 255

crlfbooleanrequired

Use CRLF line endings (Excel-friendly) vs LF

bombooleanrequired

Write UTF-8 BOM (Excel-friendly on Windows)

csv_injection_hardeningbooleanrequired

Protect against CSV injection by prefixing a single quote to dangerous prefixes (=+-@)

empty_density_thresholdnumber:floatrequired

Consider a row/col "empty" if non-empty density below this (0.0..1.0)

format float

gap_break_rowsinteger:uintrequired

Break between tables if we see >= this many consecutive empty rows

format uintmin 0

gap_break_colsinteger:uintrequired

Break between tables if we see >= this many consecutive empty cols

format uintmin 0

allow_internal_blank_rowsinteger:uintrequired

Allow up to this many blank rows *inside* a table

format uintmin 0

allow_internal_blank_colsinteger:uintrequired

Allow up to this many blank cols *inside* a table

format uintmin 0

min_table_cellsinteger:uintrequired

Minimum non-empty cell count for a rectangle to be considered a table

format uintmin 0

max_header_rowsinteger:uintrequired

Max header rows to consider when flattening

format uintmin 0

max_left_header_colsinteger:uintrequired

Max left header columns to detect

format uintmin 0

header_joinerstringrequired

Joiner to flatten multi-row headers

drop_totalsbooleanrequired

Drop totals rows matching regex (case-insensitive)

stitch_across_spacersbooleanrequired

Allow merging rectangles across large blank/merged "spacer" bands

stitch_type_sample_rowsinteger:uintrequired

Sample size for type inference per column when stitching

format uintmin 0

stitch_min_type_match_rationumber:floatrequired

Minimum ratio of compatible column types to allow stitching (0.0..1.0)

format float

stitch_min_col_overlapnumber:floatrequired

Minimum required column-overlap (intersection / union) to consider adjacency

format float

+11 more fields

Default {"delimiter":44,"crlf":false,"bom":false,"csv_injection_hardening":true,"empty_density_...

Schema enforced

Output Pins

2

Output

Execution

exec_out

Next

Tables

Struct Array

tables

Extracted Vec<Table>

SchemaCSVTableCSVTableCSVTable4 fields

namestring | null

Optional name/identifier for this table

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