|
Re: Support for Multiple Excel worksheets [message #368535 is a reply to message #368511] |
Mon, 08 June 2009 15: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 #368568 is a reply to message #368554] |
Wed, 10 June 2009 16: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
>
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.02328 seconds