Multiple sheet excel report template generation in Oracle BI Publisher 10g

Objective:
To
create template for generating multiple sheet excel in Oracle BI Publisher 10g.
Solution:
Template
Creation – EXCEL

Step 1: Excel contains the below template with Sheet1 and 2 as follows



Step 2: Go to
Formulas => Name Manager – See the XDO call
Step 3: Go to Sheet2
(XDO_METADATA) – See the XSLT code
Step 4: Come to
Sheet1 – See how the groupings were done
Note:  
Ø  Workout example
screenshot shared below.  
Ø  Template has
been attached separately with this component.

Output: Output will
be multiple sheets.



By
Karkuvelraja T
  • January 2, 2017 | 26 views