cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From warrell harries <warrell.harr...@gmail.com>
Subject Re: Upgrade of HSSF to XSSF Excel serializer, anyone?
Date Tue, 13 May 2014 14:47:13 GMT
Hi Again,

I had a go at upgrading the serializer to XSSF  but there were simply too
many Java class changes for lazy old me. Instead, I had much better mileage
going down the OpenXML road and generating an .xlsx file in the Cocoon
pipeline (it is only a zipped up bunch of XML files after all).

All the files are fairly straightforward XML and it is only the packaging
that would be tricky but for the invaluable Zip serializer.

Inevitably, there is a lot of googling required to find examples but I
recommend
http://blogs.msdn.com/b/brian_jones/archive/2007/05/29/simple-spreadsheetml-file-part-3-formatting.aspx

as a good place to start.

Cheers

Warrell



On 9 May 2014 09:58, warrell harries <warrell.harries@gmail.com> wrote:

> Hi Cocooners,
>
> I have just run into the 65535 upper limit on the number of rows in an
> Excel workbook as serialized using the gnumeric schema.
>
> Of course, I tried substituting the latest poi-3.10 jar from the excellent
> POI project for 3.0.2.jar that has worked well so far. Alas, some of the
> methods no longer exist.
>
> I was hoping somebody has done the hard-work necessary to upgrade the
> serializer to the XSSF format. I would be very grateful if they could share
> the code for 2.11
>
> Thanks
>
> Warrell
>

Mime
View raw message