Skip to Main Content

General Development Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Creating Excel Template with multiple tabs for BI Publisher.

L_a_u_r_aOct 31 2023

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.

Comments
Post Details
Added on Oct 31 2023
0 comments
117 views