Set Content of Column

This action sets the content of a column in a spreadsheet from a variable of complex type. The attribute values of the variable is inserted consecutively beneath each other starting from the first cell of the found range.

Properties

The Set Content of Column action can be configured using the following properties:

Variable

This property specifies the name of a variable that stores the cell values.

Date Format

If any of the inserted cell values is a date then this property may be used to specify the date format of the cell. Options are:

  • Value - Sets the format directly
  • Variable - Specifies a variable that stores the format.
  • Expression - Creates an expression to specify the format.
  • Converters - Specifies a data converter to set the format.