How to get xlsx output from XML Publisher in Oracle Apps R12 instead of xls
Hi,
I am trying to get outputs in multiple worksheets from XML Publisher in Oracle Apps R12.
While designing the template, I am defining different sections in different pages with a page break.
On desktop previewer for BI Publisher, there are two different types of Excel Previews Available:
1) Excel
2) Excel2000
While previewing my rtf template with Excel option, I am getting the desired output, i.e. different sections(defined with page break) in different worksheets.
But on previewing with Excel2000, I am getting all the sections on one worksheet only.
While running the concurrent program, I am getting the same output as Excel2000 previewer option.