It's all about the answers!

Ask a question

BIRT: Generate report to xlsx format

Vladimir Amelin (70472226) | asked Oct 21 '13, 6:39 a.m.

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!

Vladimir Amelin commented Oct 21 '13, 8:18 a.m.

Thank you, Joseph. Is it possible to export to .xslx in RRDI\Insight? 

Accepted answer

permanent link
Joseph Mao (440189) | answered Oct 21 '13, 7:54 a.m.
 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

permanent link
Irina Vaganova (4111113) | answered Oct 22 '13, 5:44 a.m.
 Hi, Vladimir 
You could export your report to .xlsx format in RRDI\Insight. Also you could export in two format: Excel2002, Excel2007.

permanent link
Bill Taylor (1441533) | answered Apr 09 '14, 1:32 a.m.
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

Register or to post 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.