Difference between revisions of "Multisheet Templates"

Line 10: Line 10:
  
 
[[File:Sample Template.xlsx]]
 
[[File:Sample Template.xlsx]]
 +
 +
The output sheets are configured in a separate area as shown here
 +
[[File:MultisheetTemplate_SampleConfig.PNG|center|600px]]

Revision as of 16:32, 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

MultisheetTemplate SampleTemplate.PNG

Creates this output

MultisheetTemplate SampleOutput.PNG

File:Sample Template.xlsx

The output sheets are configured in a separate area as shown here

MultisheetTemplate SampleConfig.PNG