Difference between revisions of "Multisheet Templates"
| Line 8: | Line 8: | ||
Creates this output | Creates this output | ||
[[File:MultisheetTemplate_SampleOutput.PNG|center|600px]] | [[File:MultisheetTemplate_SampleOutput.PNG|center|600px]] | ||
| + | |||
| + | Using this configuration | ||
| + | [[File:MultisheetTemplate_SampleConfig.PNG|center|600px]] | ||
[[File:Sample Template.xlsx]] | [[File:Sample Template.xlsx]] | ||
| − | The output | + | ==Basic Configuration== |
| − | + | The output sheet configuration must be in a named range called {{code|SheetsConfig}}, and at a minimum it must contain the following columns: | |
| + | |||
| + | {{TableHeader}} | ||
| + | | {{code|SheetName}} | ||
| + | | Name of the output sheet to create. | ||
| + | |- | ||
| + | | {{code|ColumnHierarchies}} | ||
| + | | Name of range containing the column hierarchies. | ||
| + | |- | ||
| + | | {{code|ColumnMembers}} | ||
| + | | Name of range containing the column members. | ||
| + | |- | ||
| + | | {{code|RowHierarchies}} | ||
| + | | Name of range containing the row hierarchies. | ||
| + | |- | ||
| + | | {{code|RowMembers}} | ||
| + | | Name of range containing the row members. | ||
| + | {{TableFooter}} | ||
Revision as of 16:40, 5 March 2024
Multisheet Templates allow you to create workbook with multiple sheets from a single template designed in Excel. You define ranges for the sets of column and row members available, then define how to combine them for each output sheet.
For example, we can define two sets of columns and two sets of rows, and use this to create four output sheets.
This input
Creates this output
Using this configuration
Basic Configuration
The output sheet configuration must be in a named range called SheetsConfig, and at a minimum it must contain the following columns:
| SheetName | Name of the output sheet to create. |
| ColumnHierarchies | Name of range containing the column hierarchies. |
| ColumnMembers | Name of range containing the column members. |
| RowHierarchies | Name of range containing the row hierarchies. |
| RowMembers | Name of range containing the row members. |
