rowCell
This command requires an extra license.
A child command of insertRowValues specifies a value for one of the cells of the row that the parent command is modifying.
Parent commands
insertRowValues
Required. This parent defines the row whose cell this command is modifying.
Attributes
column | ||
|---|---|---|
Required | Value type | EL-evaluated |
Yes | String, Number | Yes |
Defines the cell receiving a new value by its column. The resolved value can be a String specifying a column name, such as "A", "C" or "BW", or a String specifying the column index, such as "1", "2" or "32", or a Number specifying the index. The indexes start from 1, so column "A" is 1, "B" is 2, and so on. | ||
value | ||
|---|---|---|
Required | Value type | EL-evaluated |
Yes | Any | Yes |
Defines the new value of the cell. If the resolved value is a Number or a Boolean, the cell's type is set to numeric or boolean, as appropriate. If the value is an empty String, the cell's value is set to null. If it's a value of any other type, that value is converted into a String, and the cell type is set to text. | ||
Examples
See the examples of insertRowValues.