BIRT: Generate report to xlsx format
We use RTC 4.0.2 with bundled BIRT 2.6.2. Built-in BIRT emitter generates simple xml files when you choose to export to Excel. Some reports contain 20k+ rows which results in quite large output file (50 Mb+). Is there an option to generate compressed xml file (xlsx instead of xls)? If no such option, is there a hope to have support for compressed files in future versions of BIRT\CLM. Thanks in advance! |
Accepted answer
Hi Vladimir,
There is no option to save BIRT report as xlsx format.
While the report export feature is provided by BIRT, rather than RTC.
xls for excel format is readable by all Excel version, including version older than 2007.
From long term, RTC will recommend using RRDI as the report engine, which support XML format already.
Vladimir Amelin selected this answer as the correct answer
|
2 other answers
Hi, Vladimir
You could export your report to .xlsx format in RRDI\Insight. Also you could export in two format: Excel2002, Excel2007.
|
BIRT doesn't actually export in .xlx format. It exports XML but gives the file an xls extension so that it is opened by Excel.
If your suffering from the 64K line limited, just change the file extension to xlsx. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
Thank you, Joseph. Is it possible to export to .xslx in RRDI\Insight?