setCellValue
This command requires an extra license.
A child command for modifyWorkbook that sets a new value for a cell on the workbook. This will overwrite any existing value in the cell.
Parent commands
modifyWorkbook
Required. This parent defines the workbook that is modified.
Attributes
cell | ||
|---|---|---|
Required | Value type | EL-evaluated |
Yes | String | Yes |
Defines the cell that receives the new value. The resolved String is expected to specify the column and row, like "D44" for the cell in column D, row 44. | ||
sheet | ||
|---|---|---|
Required | Value type | EL-evaluated |
Yes | String | Yes |
Defines the sheet where the target cell is in. The resolved String is expthected to be a name of a sheet in the workbook. | ||
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
Add one setCellValue command for every cell whose value you wish to modify.
<modifyWorkbook var="modifiedWorkbook" workbook="${workbook}"> <setCellValue cell="B4" sheet="Sheet1" value="${differentValue}"> <setCellValue cell="C4" sheet="Sheet1" value="${differentMultiplier}">If you're setting fixed values into cells, be particularly careful when setting numbers. A number that is not wrapped with the EL-expression notation is actually a String, and String values do not function as the numbers they may look like when they are components of formula cells' calculations. So, if you'd like to set a cell's value as the number 22 for example, set the value attribute into ${22}, not 22.