Eclipse Community Forums: BIRT » Support for Multiple Excel worksheets

Help

Home

Home » Eclipse Projects » BIRT » Support for Multiple Excel worksheets

Show: Today's Messages :: Show Polls :: Message Navigator

Support for Multiple Excel worksheets [message #368511]

Fri, 05 June 2009 09:47

Kyle S. Bober
Messages: 4
Registered: July 2009

Junior Member

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.

Report message to a moderator

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

Report message to a moderator

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

Tue, 09 June 2009 12:38

Kyle S. Bober
Messages: 4
Registered: July 2009

Junior Member

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

Report message to a moderator

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
>

Report message to a moderator

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

Mon, 16 July 2012 07:25

shahin ansari
Messages: 1
Registered: July 2012

Junior Member

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

Report message to a moderator

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

Mon, 16 July 2012 22:50

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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
>

Jason Weathersby

BIRT Exchange

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 01:35:25 EDT 2013