poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hamu, Dave" <Dave.H...@Avnet.com>
Subject RE: Too Many cell formats
Date Tue, 18 Jan 2005 13:56:05 GMT

Excel caches cell formats and styles, so instead of creating a cell
format for each cell, create cell format objects and reuse them.

For example, if  you will be rendering cells with currency, dates,
ordinary text and integers, create four variables as follows:


Use the HSSF API to instantiate just one format for each cell type that
you are constructing and then reuse those (in this example, 4) formats.

If you don't do this you end up creating an excel document with a bunch
of redundant "header" material and Excel wasn't designed to work this
way.  Keep in mind when working with POI, or any other Java API for
Excel that these tools have reverse engineered Excel's file format.
That means that you can do things with the API which Excel was never
intended to do.

-----Original Message-----
From: Lalitha Prasad [mailto:lalithind@hotmail.com] 
Sent: Tuesday, January 18, 2005 6:38 AM
To: poi-user@jakarta.apache.org
Subject: Too Many cell formats


I am new to POI. I am generating more no. of rows. It is giving one
alert message "Too Many different cell formats".

what might be the reason?.

Anyone please help me.

Attached the Exception screenshot.

Thanks in advance,

Try the all-new MSN Search! Find exactly what you want. 
http://search.msn.co.in Get more value for your time.

To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

View raw message