BIRT: Generate report to xlsx format

Vladimir Amelin (704●7●22●26) | 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!

Comments

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 (440●1●8●9) | answered Oct 21 '13, 7:54 a.m.
JAZZ DEVELOPER

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

Most liked answers|Newest answers ↑|Oldest answers

0	permanent link Bill Taylor (144●15●29) \| 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.

2	permanent link Irina Vaganova (41●1●11●13) \| 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.

It's all about the answers!

Related questions

BIRT: Generate report to xlsx format

Accepted answer

2 other answers

Your answer