Skip to main content

Excel: Extract values from row

Get multiple values from an Excel row.

Parameters

Columns to extractrequired

Define one or more columns to extract values from.

Columnrequired
The Excel column letter (A, B...).
Label

Display label for the output connector. If left empty, it falls back to a generated <column> (<type>) label.

Value typerequired
The type of the value to extract.
Mandatory

Rows added via the UI start with Mandatory off. When off, the output connector is optional and a missing column, empty cell or cast failure silently emits nothing on that connector. When on, any of those errors fails the node.

Ignore errors
Ignore errors when extracting values.

Input

Excel rowrequired
The row from an Excel sheet.

Output

Values

One or more values extracted from the Excel row.