Skip to main content

Excel: Assign values to row

Assign multiple values to an Excel row.

Parameters​

Columns to loadrequired

Define one or more columns to load values to.

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

Relevant label to understand the column. If left empty, it falls back to a generated <column> (<type>) label.

Value typerequired
The type of the value to load.
Mandatory

Off by default. When on, the column's input connector becomes required and a missing value at runtime fails the node ( XLSXMissingValueForColumn). When off, the connector stays optional and a missing value writes an empty cell for that column.

Input​

Values

One input connector per configured column, in the configured type. These inputs are optional by default; a connector is required only when its column's Mandatory parameter is on.

Output​

Excel row
The row to an Excel sheet.