setDefinedNameValue
This command requires an extra license.
A child command for modifyWorkbook that sets a new value for a cell referenced by a defined name. If the defined name refers to an area rather than a single cell, the new value is set into the first (top-left) cell of the area.
Parent commands
modifyWorkbook
Required. This parent defines the workbook that is modified.
Attributes
name | ||
|---|---|---|
Required | Value type | EL-evaluated |
Yes | String | Yes |
Defines the defined name whose cell receives the new value. | ||
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 setDefinedNameValue command for every defined name whose referenced value you wish to modify.
<modifyWorkbook var="modifiedWorkbook" workbook="${workbook}"> <setDefinedNameValue name="CarrotPrice" value="${newCarrotPrice}"> <setDefinedNameValue name="BlueberryShipments" value="${expectedBBShipments}">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 15 for example, set the value attribute into ${15}, not 15.
Also s,ee the documentation of evalFormulas for an example of using this command to execute dynamic formula alterations.