Support for exporting data to multiple Excel worksheets

Hi,

I'm new to BIRT, so I apologize in advance if this question has already been addressed. When using the web viewer, is their a way to export the report to multiple Excel worksheets, but within a single workbook? For example, if I have a report with multiple logical page breaks, then can these separate pages be exported to separate worksheets in one fell swoop?

I've been searching the forums, but haven't yet found an answer to this particular end. Furthermore, I was hoping to download the source code for the XLS emitter to see exactly how the Excel XML is generated. In case the aforementioned functionality had not yet been implemented, I figured there might be a way to work the worksheet tag into the code. However, the java code does not seem to be present in the CVS repository (/cvsroot/birt/source/source BIRT_2_2_1_Release_20070924). Was I looking in the wrong source directory?

Thanks,

Mike

Find more posts tagged with

Comments

Nits

I have been visiting various forums including this one in search for the same solution however there doesnt seem to be any solution as of now for exporting data to multiple worksheets.

Probably we should try entering this request in the BugZilla of BIRT and wait for this feature to be included in next release.

If anyone has a work around for the same, your inputs would be highly appreciated.

Nits

mike

Thanks for your reply Nits. I noticed that there has been a Bugzilla request for this feature: [BIRT] Bug# 205755. In the meantime, I'm working on a temporary hacked solution for this problem. If I'm able to get the emitter working properly, I will post the code to this forum.

-Mike

scaracas

You're trying to do recoding the emitter with BIRT for something that's native in eSpreadsheet product.

However , having "tabs" in BIRT , and having them exported to Excel Sheets sounds like a great idea. We'll study this.

For the time being , If this is your only need ( connect to DB and supply refined Excel files with business rules , filters , grouping and multiple sheets ) then i suggest taking a look at eSpreadsheet as well.

kylebober

Has there been any progress made in regards to generating worksheets for Excel report generation in BIRT??? I tried to locate the bug # 205755 but had no luck finding it on the Eclipse BIRT Bugzilla. Has anyone figured out a workaround?

kylebober

Has anyone figured out a way to support multiple worksheets in a BIRT report? I have found nothing conclusive. Supposedly eSpreadsheet provides this feature but we are looking for an open source solution and want to use the existing BIRT Report Engine. I was thinking it may be possible to generate multiple BIRT reports and export them into individual Excel files then open those files using Apache POI and get the individual worksheets. Then create a master Excel file and add the individual worksheets. I know this is a more programmatic appraoch but it may work for the time being. Until support for multiple worksheets in BIRT is available.

chuston

eSpreadsheet is way beyond my needs. Right now I can create multiworksheet workbooks with XSL and the MS Office XML file format. I don't have formulas/lists/etc. defined. I just want the users to be able to work with the data without going through a bunch of import steps. So here's another vote for a decent excel emitter.

-- Chris

marcd

Am evaluating BIRT, do like it, but this is inability is a show stopper.

A Page Break in PDF should map to a new worksheet in Excel

anitat

I also need this feature. Has anyone got the solution to support multiple worksheets in a BIRT report?