I need to create a template with an Excel Workbook output with multiple Worksheets. I am running into 2 problems.
First, I need to create a template with different reports in seperate tabs. I followed the steps in this document (BI Publisher: How to create Multisheet in Single Excel file using Excel Template (Doc ID 1352000.1)), but this is spliting the data from a single query into seperate worksheets. Is there a way to have different queries/reports in different worksheets within the same workbook?
Second, I'm having difficulty saving a template created from Excel in a format I can upload into XML Publisher and get an Excel output.