Skip to main content
Skip table of contents

setDefinedNameValue

The Excel output functionality requires additional licenses. Please contact support@documill.com to enable the licenses.

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.

CODE
<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 see the documentation of evalFormulas for an example of using this command to execute dynamic formula alterations.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.