Monday, 2 January 2017

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


To create template for generating multiple sheet excel in Oracle BI Publisher 10g.


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

Ø  Workout example screenshot shared below.  
Ø  Template has been attached separately with this component.

Output: Output will be multiple sheets.

Karkuvelraja T


  1. If you need your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees (no matter why you broke up) you must watch this video
    right away...

    (VIDEO) Get your ex back with TEXT messages?

  2. If we have multiple columns to take sum of in the same sheet, How shall we write the metadata sheet. Please suggest

  3. Nice blog about punchout XML, it's being great to read this.
    CXML Punchout

  4. cXML PunchOut - Commerce extensible markup language application who is a protocol created by Ariba used to communicate between sessions across the internet.
    Commerce Extensible Markup Language Punchout

  5. Nice Blog..XML and provides formal XML schemas for business transactions.
    cXML Ariba