Menu

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.

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

Comments

0 comments