composeXLSXContent

Evaluates the Excel content commands within the specified XLSX workbook. The result of the evaluation will be a copy of the XLSX workbook with whatever modifications the content commands caused.

This command triggers an evaluation process specifically only for Excel content commands, not the older defined Name tags produced through the Dynamo Office Add-in. Use the composeContent command for composing contents of legacy XLSX templates.

Child commands

evaluateTag
Optional. Add one or more of these to limit the commands that are evaluated.

Attributes

var
Required	Value type	EL-evaluated
Yes	String	No
Defines the name of the variable placed into the variable context whose value is the evaluated workbook File.

template
Required	Value type	EL-evaluated
No	File	Yes
Defines the XLSX template whose content is evaluated.

title

Required

Value type

EL-evaluated

No

String

Yes

Defines a title for the composed XLSX workbook.

If undefined, the title of the File defined through template is used as the title.

Examples

Use composeXLSXContent within an Online template's Flow to create Excel output. Simply load an Excel file that includes content commands and use composeXLSXContent to compose the workbook.

CODE

<load var="excelFile" contentDocumentId="zzzz"><composeXLSXContent var="composedXlsx" template="${excelFile}" title="Worksheets of Excelling Examples">