I have an Excel Template with Sheet1 and XDO_METADATA sheet. When I use XDO_?ELEMENT_NAME? in sheet1 everything is fine.
Now my question. Is ist possible to add another sheet in the excel-file - sheet2. And then reference data in this sheet as well, using XDO_?ELEMENT_NAME? ?
So far I only get this error, when I call the preview:
at java.util.Vector.elementData(Unknown Source)
at java.util.Vector.elementAt(Unknown Source)
Or is there another solution?
Thanks a lot
check this https://blogs.oracle.com/xmlpublisher/entry/multisheet_excel_output
not much resources on how to do this template
you can also try using some conversion utility from http://xlspe.com/news.php but we have to purchase this to use in production environment .
no its not possible as far as i know if you need different columns in different sheets you need to use xsl excel template only .
u can do it using rtf template but it wont be as same as regular excel output and you should be on bi publisher 11g to do that u can do like this
when u preview xslx output using bi publisher rtf template it treats page breaks as new sheet
ID NAME NUMBER
ID DEPT ACCOUNT#
Use the "helpful" or "correct" buttons to award points to replies / Mark the thread as answered, if your question is answered.