Eclipse Community Forums: BIRT » Support for Multiple Excel worksheets

Home » Archived » BIRT » Support for Multiple Excel worksheets

Support for Multiple Excel worksheets [message #368511]

Fri, 05 June 2009 09:47

Eclipse User

Is there 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.

Re: Support for Multiple Excel worksheets [message #368535 is a reply to message #368511]

Mon, 08 June 2009 11:21

Eclipse User

Originally posted by: jasonweathersby.windstream.net

Kyle,

Your solution is the only one I am aware currently.

Jason

Kyle S. Bober wrote:
> Is there 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.
>

Re: Support for Multiple Excel worksheets [message #368554 is a reply to message #368535]

Tue, 09 June 2009 12:38

Eclipse User

Jason,
I ran into an issue with my stated approach. It seems that the XLS
Emitter that is shipped with BIRT 2.3.2.1 is generating the report in
Excel 2003 XML format. Apache POI only supports OLE 2 and OOXML format. (I
checked various other Java Excel APIs and none have support for Excel 2003
XML format) Basically Excel Binary and OpenOfficeXML format. Is there a
way to have the BIRT XLS Emitter generate the report in either of these
formats, optimally in a Excel Binary format? I noticed that the
EXCELRenderOption object has a method to set the version of office but I
am not sure if this will change the output format of the generated report.
Any advice in this regard?

-Kyle

Re: Support for Multiple Excel worksheets [message #368568 is a reply to message #368554]

Wed, 10 June 2009 12:03

Eclipse User

Originally posted by: jasonweathersby.windstream.net

Kyle,

The emitter uses spreadsheetML which you should be able to do with a xml
writer. If you want an idea on it checkout the ExcelWriter.java class
from the excel emitter.

Jason

Kyle S. Bober wrote:
> Jason,
> I ran into an issue with my stated approach. It seems that the XLS
> Emitter that is shipped with BIRT 2.3.2.1 is generating the report in
> Excel 2003 XML format. Apache POI only supports OLE 2 and OOXML format.
> (I checked various other Java Excel APIs and none have support for Excel
> 2003 XML format) Basically Excel Binary and OpenOfficeXML format. Is
> there a way to have the BIRT XLS Emitter generate the report in either
> of these formats, optimally in a Excel Binary format? I noticed that the
> EXCELRenderOption object has a method to set the version of office but I
> am not sure if this will change the output format of the generated
> report. Any advice in this regard?
>
> -Kyle
>

Re: Support for Multiple Excel worksheets [message #895864 is a reply to message #368568]

Mon, 16 July 2012 07:25

Eclipse User

Dear All,

I working with birt-report .and there is requirement to create multiple worksheet .

but i don't know how to create multile worksheet .

so kindly provide me step for create multiple worksheet in birt report

Thanks and best regards
shahin ali ansari
a.shahin1982@gmail.com

Re: Support for Multiple Excel worksheets [message #896038 is a reply to message #895864]

Mon, 16 July 2012 22:50

Eclipse User

Have you tried this plugin for BIRT?
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/

Jason

On 7/16/2012 7:25 AM, shahin ansari wrote:
> Dear All,
>
> I working with birt-report .and there is requirement to create multiple
> worksheet .
>
> but i don't know how to create multile worksheet .
>
> so kindly provide me step for create multiple worksheet in birt report
>
>
> Thanks and best regards
> shahin ali ansari
> mailto:a.shahin1982@xxxxxxxx
>

Previous Topic:	Example for drill down feature
Next Topic:	Birt rcp report designer 4.2.0 does not lauch

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 03 13:45:59 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter