12.1.3 - xlsx output from XML Publisher

Question

Summary

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

Brajesh Shukla-95078 · Answer

Patch mentioned in the earlier document is required to see excel template type in R12.1.3

Brajesh Shukla-95078 · Answer

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. AAA BBB . . . etc. 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)

Brajesh Shukla-95078 · Answer

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.