Register Excel (DataFusion) Node

R

Data/DataFusion

Registers an Excel workbook's sheets as SQL tables in a DataFusion session. Tables are named after their normalized sheet names (e.g. 'Sales Data (2024)' becomes 'sales_data_2024'); additional tables on the same sheet get numeric suffixes. The download and parse are deferred until a query actually uses the session — unless the Table Names output is connected, which requires parsing here.

df_register_exceldata

Inputs6

Outputs2

Security exposure10/10

Packagedata

Ratings

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

SecurityAttack surface and exposure impact.

10/10High

PrivacyPotential sensitivity of processed data.

10/10High

PerformanceRuntime or resource pressure.

8/10High

GovernancePolicy, audit, or compliance impact.

9/10High

ReliabilityOperational stability considerations.

9/10High

CostExternal or compute cost impact.

10/10High

Input Pins

6

Input

Execution

exec_in

Trigger execution

Session

Struct

session

DataFusion session to register the tables into

SchemaDataFusionSessionDataFusionSessionDataFusionSession1 fields

cache_keystringrequired

File

Struct

file

Excel file

SchemaFlowPathFlowPathFlowPath3 fields

pathstringrequired

store_refstringrequired

cache_store_refstring | null

Schema enforced

Sheet

String

sheet

Worksheet name (optional - if empty, registers all sheets)

Mode

String

mode

'Sheet as table' registers each sheet's used range as one table; 'Detect tables' finds and registers every table on each sheet

Default Sheet as table

Sheet as tableDetect tables

Name Prefix

String

prefix

Optional prefix for the registered table names

Output Pins

2

Done

Execution

exec_out

Tables registered successfully

Table Names

String Array

table_names

Names the tables were registered under. Connecting this pin makes the workbook parse eagerly at this node instead of at the first query.

Node Info

Internal name

df_register_excel

Category

Data/DataFusion