Objective:
To
create template for generating multiple sheet excel in Oracle BI Publisher 10g.
create template for generating multiple sheet excel in Oracle BI Publisher 10g.
Solution:
Template
Creation – EXCEL
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
Formulas => Name Manager – See the XDO call
Step 3: Go to Sheet2
(XDO_METADATA) – See the XSLT code
(XDO_METADATA) – See the XSLT code
Step 4: Come to
Sheet1 – See how the groupings were done
Sheet1 – See how the groupings were done
Note:
Ø Workout example
screenshot shared below.
screenshot shared below.
Ø Template has
been attached separately with this component.
been attached separately with this component.
Output: Output will
be multiple sheets.
be multiple sheets.
By
Karkuvelraja T
Recent Posts