Mailing List
Home
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 ...
Subjects
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
CREATING WAR Files
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
attribute
Printing problem
InstantiationException
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 ?
 
Search:  
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)

 Back
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
-- --
                                                                             
                                                       
                     Sanjeeva                                                
                                                       
                     Parwatikar               To:       poi-user@(protected)
.apache.org                                                  
                                              cc:                            
                                                       
                     01/16/2004 03:38         Subject:  Excel: Too many
different  cell formats                                      
                     PM                                                      
                                                       
                                                                             
                                                       
                                                                             
                                                       



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
http://www.mail-archive.com/poi-user@(protected)/msg01529.html

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.