Excel Reader (non-tabular)

Reads one or more .xlsx files containing form-structured (non-tabular) worksheets and extracts field values into a standard KNIME data table. The form structure is defined by a connected input table that maps field names to Excel cell addresses (e.g. C4, B10:D15). The form definition table requires two columns: Name (the output column name) and Cell Range (the Excel cell address or range). Two optional columns are supported: Content Type ("data" or "label", defaults to "data") and Data Type (string, int, double, date, or boolean, defaults to string). Each worksheet produces one output row in wide mode, or one row per field in long mode. Label fields (Content Type = "label") can optionally be included in port 0 and/or output separately to port 1. Supports single file, all sheets in a workbook, folder, and recursive folder reading modes.

Options

General

Input — Single File / Folder

Select Single File to read from one .xlsx file. Select Folder to read all matching .xlsx files from a directory. Enables the corresponding tab page and disables the other.

Output format

Wide: produces one row per form instance (file/sheet pair), with one column per field defined in the mapping table. Long: produces one row per field per form instance, with fixed columns field_name and value.

Include source filename

When enabled, adds a Source File column as the first column in the output table, containing the absolute path of the source .xlsx file.

Include sheet name

When enabled, adds a Sheet Name column as the second column in the output table (after Source File if enabled), containing the worksheet name.

Include label fields in port 0

When enabled, fields with Content Type = "label" are included in the main output table (port 0) alongside data fields, preserving the definition table order. When disabled, only data fields appear in port 0.

Output label fields in port 1

When enabled, label fields are extracted and output to port 1 as a separate table with fixed columns: Name, Cell Range, and Cell Content (the extracted value), plus optional provenance columns. When disabled, port 1 produces an empty table.

Include format condition operator columns

When enabled, adds a Format Condition Operator column immediately after each field value column in wide mode, or as an additional fixed column in long mode and port 1. The column contains the conditional formatting rule operator(s) applied to the cell (e.g. BETWEEN, EQUAL, GT). Multiple operators are concatenated with the range delimiter. Missing value when no conditional formatting rule is applied to the cell.

Include validation type columns

When enabled, adds a Validation Type column immediately after each field value column (and after the Format Condition Operator column if enabled) in wide mode, or as an additional fixed column in long mode and port 1. The column contains the data validation type applied to the cell (e.g. LIST, INTEGER, DATE). Multiple types are concatenated with the range delimiter. Missing value when no data validation rule is applied to the cell.

On missing cell

Warn and insert missing value: if a cell address cannot be resolved, a missing value is written and a warning is logged. Fail: the node fails immediately on the first unresolvable cell.

On unparseable value

Warn and insert missing value: if a cell value cannot be converted to the declared Data Type, a missing value is written and a warning is logged. Fail: the node fails immediately on the first conversion error.

File

Read from

The file system to read from. Currently only Local File System is supported. Additional file systems (mountpoint, relative to) may be added in a future release.

File

The path to the .xlsx file to read. Use the Browse button to open a file chooser filtered to .xlsx files.

Process single sheet

Read exactly one worksheet from the selected file using one of three selection methods: First (the first non-hidden sheet with data), By name (select from a dropdown of available sheets), or By position (0-based index).

Include hidden worksheets (single)

When enabled, hidden worksheets are included when determining the first sheet or populating the By name dropdown. When disabled, hidden sheets are excluded.

Process many sheets

Read all matching worksheets from the selected file. Use All to include every sheet, Blacklist to exclude named sheets, or Whitelist to include only named sheets. Sheet names are comma-separated and matched case-insensitively.

Include hidden worksheets (many)

When enabled, hidden worksheets are included when processing many sheets. When disabled, hidden sheets are skipped.

Folder

Read from

The file system to read from. Currently only Local File System is supported.

Folder

The path to the folder containing .xlsx files to read. Use the Browse button to open a folder chooser.

Include subfolders

When enabled, .xlsx files in all subfolders are also included recursively.

Include hidden folders

When enabled, hidden subfolders are included during recursive scanning. Only available when Include subfolders is checked.

Filter by file extension

When enabled, only files matching the specified extensions (comma-separated, default: xlsx) are included. When disabled, all files in the folder are considered.

Include hidden files

When enabled, hidden files are included in the folder scan.

Process single sheet

Read exactly one worksheet from each file using First, By name (text input), or By position (0-based index).

Include hidden worksheets (single)

When enabled, hidden worksheets are considered when selecting the sheet per file.

Process many sheets

Read all matching worksheets from each file. Use All, Blacklist, or Whitelist with comma-separated sheet names.

Include hidden worksheets (many)

When enabled, hidden worksheets are included when processing many sheets per file.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers