RTF to Excel Report is not coming proper using BI Publisher API.
Hi,
I have used Agile DOC Publisher code to convert RTF file to Excel file and the Report is not coming correct. Image , color and format of the report is lost.
My requirement is to create a Excel Fixed format Report using BI Publisher API(xdocore.jar). Please assist on this.
Thanks.
Hi Mala,
what happens if you generate docx file instead of Excel? Are Images, colors, etc preserved?
If you want more proper Excel generation, I would use the POI library, xdocore for me works best if I create PDFs, Docx and html.
Best regards,
Dennis
Hi Dennis,
Yes if i generate doc or pdf file then the format is perfect. everything is coming (Images, colors and format). I have issue only with excel.
So does it mean BI Publisher won’t help for Excel type report.
I tried using Apache POI but that also didn’t help. I have created a sample Excel template and when i am modified it with POI API , the output file contains only updated data and all old data are omitted (Images, format and color everything).
Please assist if there is any other easiest method to fulfill this requirement.
Hi Mala,
I just test created a Excel file with BIPublisher. Colors, images, list entries and repeating groups did work well for Excel. Even html was printed. Have you checked that you have all required libraries for xdocore to work?
Is it Excel 2000 format you are trying to generate?
Best regards,
Dennis
I had a lot of issue exporting a RTF Template toExcel file (merged rows, colours, format issues)
If report has to be always exported to XLS I suggest to use an Excel template (http://docs.oracle.com/cd/E21764_01/bi.1111/e13881/T527073T571887.htm)