Element Details: Excel+Template
 Back


Available in: Logi Info Source code name: ExcelTemplate

The ExcelTemplate element represents one Excel workbook.

* Only one ExcelTemplate element is permitted per Template definition.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ExcelTemplateFilename
UserDefined
(Required) Type the name of the Excel template file to use for this definition.
ExcelTemplateMode
OneWorksheetPerDataRow
OneWorksheet
The following two output modes are available for Excel templates: * One Worksheet * One Worksheet Per Data Row Select "OneWorksheet" mode to output each datarow from all the data layers to the template's workbook. Select "OneWorksheetPerDataRow" mode to create a copy of the template's workbook layout for each datarow in the data layers. For example, the Excel template contains two worksheets: Employees and Orders. The Template definition contains two PatternBlock elements - one that retrieves employee data and one that retrieves orders data. The employees PatternBlock outputs data to the Employees worksheet and the orders PatternBlock outputs data to the Orders worksheet. If there are 10 datarows for each DataLayer under the PatternBlock elements and "OneWorksheetPerDataRow" is selected, there will be 10 copies of the Employees worksheet and 10 copies of the Orders worksheet in the final workbook.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.



PARENT ELEMENTS

Click element to drill down for more information.

Template


CHILD ELEMENTS

Click element to drill down for more information.

Pattern Block


 Back to top