Mailing List
Forum Home
Maven - Project building tool
Axis - Java SOAP implementation
Cocoon - MVC web framework based on XML/XSL
Lucene - Full-featured text search engine APIs
Log4J - A log library
Fop - Create PDF, PCL, PS, SVG, XML driven by XSL formatting objects.
POI - Java Excel, Word and other Microsoft Office files manipulating library
Oracle database error code ...
log4j warning: No appenders could be found
java security AccessControlException: access denied (java io FilePermission clie
java lang InstantiationException: org apache tools ant Main
Apache Axis Tutorial
Struts <logic iterate >
log4j properties How to parse outpu to multiple files
configuring log4j with BEA Weblogic 8 1
How to use XSL FOP Java together
JSP precompile
Servlet File Download dialog problem (IE6,Adobe 6 0)
Proposal: Adding jar manifest classpath in jar and war plugins
Unsupported major minor version 48 0 problem while running the an
   telope task
java security AccessControlException: access denied (java io FilePermission
axis wsdl2java Ant Task usage
net sf hibernate MappingException: Error reading resource: test/User hbm xml
Building EAR ANT Script for websphere 5 0
jsp data into Excel
Classpath problem
Jboss 3 2 3+ vs Tomcat Axis Question
RE: How to include jars and add them into the MANIFEST MF/Class Path
Printing problem
Couldn 't find trusted certificate
Please : How can one install ant 1 6 0 under Eclipse 2 1 ?
Excel: Too many different cell formats
Running junit tests fails
XDoclet, Struts and Maven: Where to start? SOLUTION
1 3 final: now giving me java io FileNotFoundException (Too many
open files)
AXIS: tomcat timeout ?
Power your search with and, or, +, -, or "some phrase" operators.
Excel: Too many different cell formats

Excel: Too many different cell formats

2004-01-22       - By Sanjeeva_Parwatikar@(protected)

Reply:     1     2     3     4  

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@(protected)                                                  
                     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@(protected)
For additional commands, e-mail: poi-user-help@(protected)

Earn $52 per hosting referral at Lunarpages.