Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Support for Multiple Excel worksheets
Support for Multiple Excel worksheets [message #368511] Fri, 05 June 2009 09:47 Go to next message
Kyle S. Bober is currently offline 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.
Re: Support for Multiple Excel worksheets [message #368535 is a reply to message #368511] Mon, 08 June 2009 11:21 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Kyle S. Bober is currently offline 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
Re: Support for Multiple Excel worksheets [message #368568 is a reply to message #368554] Wed, 10 June 2009 12:03 Go to previous messageGo to next message
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 Go to previous messageGo to next message
shahin ansari is currently offline 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
Re: Support for Multiple Excel worksheets [message #896038 is a reply to message #895864] Mon, 16 July 2012 22:50 Go to previous message
Jason Weathersby is currently offline 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
>
Previous Topic:Example for drill down feature
Next Topic:Birt rcp report designer 4.2.0 does not lauch
Goto Forum:
  


Current Time: Thu Jul 31 11:38:11 EDT 2014

Powered by FUDForum. Page generated in 0.01657 seconds