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-07-03       - By Jeff Blackwell

 Back
Reply:     1     2     3     4  

Sanjeev -

Just a suggestion, but make sure that the Styles are instantiated _outside_
the loop.  The code that you linked to built a Style for each cell.  Is
yours doing this?  Might want to instantiate Style1,Style2, etc. from your
registry, then use

cell.setCellStyle(style1);

etc. to set the CellStyle in the loop.

I believe that's what the responses below the code you linked to were
saying.

Cheers,
Jeff
-- -- Original Message -- --
From: <Sanjeeva_Parwatikar@(protected)>
To: <poi-user@(protected)>
Sent: Friday, January 16, 2004 3:38 PM
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
> 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)
>
>


-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: poi-user-unsubscribe@(protected)
For additional commands, e-mail: poi-user-help@(protected)


Earn $52 per hosting referral at Lunarpages.