BI創建多sheet報表

How To Generate Multiple Reports In Multiple Tabs Of Single Excel File In OIC Using Xml Publisher [ID 1261945.1]
        修改时间 31-OCT-2010     类型 HOWTO     状态 PUBLISHED         
In this Document
  Goal
  Solution

Applies to:

Oracle Incentive Compensation - Version: 12.0.0 and later   [Release: 12.0 and later ]
BI Publisher (formerly XML Publisher) - Version: 11.1.1.3.0 and later    [Release: 11 and later]
Information in this document applies to any platform.
Goal

Customer has 6 Reports developed in OIC (Custom Reports) and would like to use the BI Publisher (formerly XML Publisher) to generate one output in Excel with Multiple Sheets (each Excel sheet for each report) in the same file.
Solution

As this is a customization, support can provide some high level suggestions.

This can be done but it is really tricky and require some setup from your end, and is achieved by following the steps in the following Oracle XML Publisher BLOG:

For multi-sheet Excel output, please see
http://blogs.oracle.com/xmlpubli ... t_excel_output.html

Also, we'd recommend you to have a look on the following topics as well as it may help in the same issue:

Real Excel Templates I
http://blogs.oracle.com/xmlpubli ... el_templates_i.html

Real Excel Templates 1.5
http://blogs.oracle.com/xmlpubli ... l_templates_15.html

For further information please log the issue with BI Publisher (formerly XML Publisher) support team for assistance.

------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------

XML Spreadsheet Reference
http://msdn.microsoft.com/en-us/library/aa140066(office.10).aspx

实例：
http://blogs.oracle.com/xmlpublisher/entry/real_excel_templates_i