Return-Path: Delivered-To: apmail-poi-user-archive@www.apache.org Received: (qmail 17738 invoked from network); 27 Aug 2007 18:26:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 27 Aug 2007 18:26:09 -0000 Received: (qmail 72521 invoked by uid 500); 27 Aug 2007 18:26:03 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 72510 invoked by uid 500); 27 Aug 2007 18:26:03 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Received: (qmail 72501 invoked by uid 99); 27 Aug 2007 18:26:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Aug 2007 11:26:03 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of apachemail@charter.net designates 209.225.8.181 as permitted sender) Received: from [209.225.8.181] (HELO mtai01.charter.net) (209.225.8.181) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Aug 2007 18:25:58 +0000 Received: from aarprv01.charter.net ([10.20.200.71]) by mtai01.charter.net (InterMail vM.7.08.02.02 201-2186-121-104-20070414) with ESMTP id <20070827182533.SYWZ18192.mtai01.charter.net@aarprv01.charter.net>; Mon, 27 Aug 2007 14:25:33 -0400 Received: from fepweb16 ([10.20.200.86]) by aarprv01.charter.net with ESMTP id <20070827182533.QSQX7137.aarprv01.charter.net@fepweb16>; Mon, 27 Aug 2007 14:25:33 -0400 Message-ID: <20070827142533.0KZMY.201766.root@fepweb16> Date: Mon, 27 Aug 2007 14:25:33 -0400 From: To: POI Users List Subject: Re: Spreadsheet File Size Cc: Tahir Akhtar In-Reply-To: <46D2E581.8030708@spectrum-tech.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) Sensitivity: Normal X-Originating-IP: X-Chzlrs: 0 X-Virus-Checked: Checked by ClamAV on apache.org That's what I thought, too. I was setting a style on each cell and upgraded to POI version 3.0 in order to be able to set a style on a column. Setting a default style for a column did not seem to have an effect on the file size. Is there another way to set styles that is better? ---- Tahir Akhtar wrote: > Look into the per-cell records you are creating. For example you might > be creating a unique Cell Format object for each cell although all the > cell contain same formatting. > apachemail@charter.net wrote: > > Does anyone have any suggestions on optimizing the file size of an Excel spreadsheet created with POI? > > > > I need to create a spreadsheet with a relatively large amout of data (5-8 full sheets with 10 or so columns) and when I create it with POI it is more than twice the size as when I create it manually. > > > > Thanks, > > > > Marshall > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org > > For additional commands, e-mail: user-help@poi.apache.org > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org > For additional commands, e-mail: user-help@poi.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org