Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

BIRT: Generate report to xlsx format

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

0 votes

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

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

3 answers
12,380 views
0 votes

Accepted answer

Permanent link
Joseph Mao
JAZZ DEVELOPER (440●1●8●9) 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

0 votes

2 other answers

Permanent link
Irina Vaganova
(41●1●11●14) 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.

2 votes

Permanent link
Bill Taylor
(144●15●35) 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.

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,130
× 324
× 230
× 64

Question asked: Oct 21 '13, 6:39 a.m.

Question was seen: 12,380 times

Last updated: Apr 09 '14, 1:32 a.m.

Confirmation Cancel Confirm