| 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. |