Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
12.1.3 - xlsx output from XML Publisher
Summary
12.1.3 - xlsx output from XML Publisher
Content
Hi
I am trying to export from XML Publisher to an excel spreadsheet with multiple sheets
I believe this cannot be done from an xls output, it has to be done from an xlsx output.
Is there anyway to force an xlsx output via XML Publisher?
I also believe it can be done by using an excel template instead of rtf but I believe this isn't available on 12.1.3 - is this correct?
Is there any solution at all to my issue?
Thanks
Answers
-
Patch mentioned in the earlier document is required to see excel template type in R12.1.3
0 -
Hi,
1. Create in single excel template.
2. Generate your XML in such a way that should group your data based on org
e.g.
<SAMPLEXML>
<G_ORG>
<Org_Name>AAA</Org_Name>
<G_DETAIL>
<detail1></detail1>
<detail2></detail2>
</G_DETAIL>
<G_ORG>
<G_ORG>
<Org_Name>BBB</Org_Name>
<G_DETAIL>
<detail1></detail1>
<detail2></detail2>
</G_DETAIL>
<G_ORG>
.
.
.
etc.
</SAMPLEXML>
3. In XDO_METADATA define two tags as
XDO_SHEET_? (you can specify the condition to move the data to new sheet)
and XDO_SHEET_NAME_? are the tags name using that you can specify your condition and can rename the workbook name. Refer the below document for more details
Now the three using these three steps....XML Publisher will automatically create number of sheet equal to your (G_ORG) and will name each sheet with that Organization
Below output will appear
For more details you can go through below meta link
BI Publisher: How to create Multisheet in Single Excel file using Excel Template (Doc ID 1352000.1)
0 -
If I understand correctly...you want Excel Output with multiple worksheet...in this case you can define your name manager accordingly in multiple sheet...data will populate in all the worksheet as per your name mapping provided.
0 -
Could you please elaborate more on your requirement "I am trying to export from XML Publisher to an excel spreadsheet with multiple sheets"?
For R12.1.3 in excel...please apply the below patch after this patch you will be able to see Excel Template type in XML Publisher
R12: How to add Microsoft Excel as Type to the Create Template List of Values in BI Publisher (Doc ID 1343225.1)
0 -
Thanks but I thought that excel templates weren't available in 12.1.3
Martin
0 -
OK Sorry - to give a bit more information:
There is an existing report that shows pension information for the full company
There is a requirement to now report this at Org level where each Org is a new tab on the spreadsheet
I have amended the pl/sql in the background to do a loop for each Org and each loop should start a new tab
I was using the command
for-each<?spreadsheet-sheet-name: {ORGANIZATION_NAME}?>
To try and create a new tab with the organization name but it's not working through the application - which I believed was a limitation of the fact the version I have 12.1.3 put it out as an xls rather than an xlsx?
I could be totally wrong though so happy to take thoughts/advice
0