Skip to main content

Excel: Get value from column

Node function to extract a cell value from an Excel row in the given type.

Parameters​

Columnrequired

The spreadsheet column to extract the cell from. (for example: A, BC).

Skip if not found
Ignore if the column is not found.
Value typerequired

The value type from the spreadsheet cell. See all types.

Skip on cast error

Ignore if column value type does not match with the configured value type.

Input​

Excel Row

required
A row from an Excel spreadsheet.

Output​

Cell value

The value extracted from the spreadsheet cell matching the configured value type.