poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sanjeeva_Parwati...@freddiemac.com
Subject Excel: Too many different cell formats
Date Thu, 22 Jan 2004 18:17:24 GMT

I resolved the issue.  Although cellStyles were highly reused  whenever the
styles were being set on the cells , I was creating temporary styles by
creating new styles. Be careful not to call workbook.createCellStyle( )
too may times  whether you use it or not.

Sanjeev Parwatikar
----- Forwarded by Sanjeeva Parwatikar/HQ/FHLMC on 01/22/2004 12:54 PM
                      Parwatikar               To:       poi-user@jakarta.apache.org     
                      01/16/2004 03:38         Subject:  Excel: Too many different  cell formats

I have excel workbook containing many sheets where each contains around
5000 cells.  The total number of cell styles created and used are less than
25 and are  maintained in a registry (highly reused).  Even though the cell
styles created are very less, I cannot open the generated excel workbook
(too many different cell formats error).

Please refer to

Sanjeev Parwatikar

To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org

View raw message