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 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.