Introduction
This post is about how to create a template for generating multiple sheet excel in Oracle BI Publisher 10g.
Template Creation – EXCEL
Step 1: Excel contains the below template with Sheet one and two 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.
Summary
This post is about how to create a template for generating multiple sheet excel in Oracle BI Publisher 10g.
Got any queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
