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