This command requires extra license.
A child command of insertRowValues that 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", 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 set to text. | ||
Examples
See the examples of insertRowValues.
Comments
0 comments