Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 82481 invoked from network); 22 Jan 2004 18:17:37 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 22 Jan 2004 18:17:37 -0000 Received: (qmail 99438 invoked by uid 500); 22 Jan 2004 18:17:27 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 99377 invoked by uid 500); 22 Jan 2004 18:17:26 -0000 Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "POI Users List" Reply-To: "POI Users List" Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 99354 invoked from network); 22 Jan 2004 18:17:26 -0000 Received: from unknown (HELO he2xmail.freddiemac.com) (4.21.132.137) by daedalus.apache.org with SMTP; 22 Jan 2004 18:17:26 -0000 Received: from mailgate.freddiemac.com (mailhub1.freddiemac.com [172.24.160.33]) by he2xmail.freddiemac.com (8.12.10/8.12.9) with ESMTP id i0MIE9QX004824 for ; Thu, 22 Jan 2004 13:14:09 -0500 (EST) Received: from notes-smtp01b.fhlmc.com (he2ntsp30.fhlmc.com [172.26.74.80] (may be forged)) by mailgate.freddiemac.com (8.12.10/8.8.5) with ESMTP id i0MIHM8j014555 for ; Thu, 22 Jan 2004 13:17:22 -0500 (EST) Received: from notes-mail01a.fhlmc.com ([172.24.99.44]) by notes-smtp01b.fhlmc.com (Lotus Domino Release 5.0.10) with ESMTP id 2004012213172128:295525 ; Thu, 22 Jan 2004 13:17:21 -0500 Subject: Excel: Too many different cell formats To: poi-user@jakarta.apache.org X-Mailer: Lotus Notes Release 5.0.10 March 22, 2002 Message-ID: From: Sanjeeva_Parwatikar@freddiemac.com Date: Thu, 22 Jan 2004 13:17:24 -0500 MIME-Version: 1.0 X-MIMETrack: Serialize by Router on NOTES-MAIL01A/SERVERS/FHLMC(Release 6.5|September 18, 2003) at 01/22/2004 13:17:21, Itemize by SMTP Server on NOTES-SMTP01B/SERVERS/FHLMC(Release 5.0.10 |March 22, 2002) at 01/22/2004 01:17:21 PM, Serialize by Router on NOTES-SMTP01B/SERVERS/FHLMC(Release 5.0.10 |March 22, 2002) at 01/22/2004 01:17:22 PM, Serialize complete at 01/22/2004 01:17:22 PM Content-type: text/plain; charset=US-ASCII X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N 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@jakarta.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@jakarta.apache.org/msg01529.html Sanjeev Parwatikar --------------------------------------------------------------------- To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: poi-user-help@jakarta.apache.org