Set Value of Cell

This action sets the value of a cell.

Properties

The Set Value of Cell action can be configured using the following properties:

Type

This property specifies the type of the value. Options are:

  • Text
  • Number
  • Logical
  • Date
  • Formula
Value

This property specifies the content of the value using an extended version of the Value Selector. Options are:

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

This property specifies the format of a cell using an extended version of the Value Selector. Options are:

  • Value - Sets a 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.