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.