Return-Path: 
 <poi-user-return-8034-apmail-jakarta-poi-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org
Received: (qmail 18083 invoked from network); 15 May 2006 07:26:34 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 15 May 2006 07:26:34 -0000
Received: (qmail 38721 invoked by uid 500); 15 May 2006 07:26:13 -0000
Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org
Received: (qmail 38645 invoked by uid 500); 15 May 2006 07:26:13 -0000
Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:poi-user-unsubscribe@jakarta.apache.org>
List-Help: <mailto:poi-user-help@jakarta.apache.org>
List-Post: <mailto:poi-user@jakarta.apache.org>
List-Id: "POI Users List" <poi-user.jakarta.apache.org>
Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
Delivered-To: mailing list poi-user@jakarta.apache.org
Received: (qmail 38627 invoked by uid 99); 15 May 2006 07:26:13 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 15 May 2006 00:26:13 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [217.110.62.81] (HELO rewemta01.rewe.de) (217.110.62.81)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 15 May 2006 00:26:12 -0700
Received: from S-KOEZ1-01.koeln.ads.risnet.de (s-koez1-01.koeln.ads.risnet.de
 [10.64.228.215])
	by rewemta01.rewe.de (Switch-3.1.8/Switch-3.1.7) with ESMTP id k4F7PgKv029362
	for <poi-user@jakarta.apache.org>; Mon, 15 May 2006 09:25:42 +0200
Received: from S-KOEZ1-01 (localhost [127.0.0.1])
	by S-KOEZ1-01.koeln.ads.risnet.de (Postfix) with ESMTP id 9D9ADB3CB
	for <poi-user@jakarta.apache.org>; Mon, 15 May 2006 09:25:42 +0200 (CEST)
Received: from rewemta03.eil.risnet.de (unknown [10.64.250.43])
	by S-KOEZ1-01.koeln.ads.risnet.de (Postfix) with ESMTP id 86DC3B3C8
	for <poi-user@jakarta.apache.org>; Mon, 15 May 2006 09:25:42 +0200 (CEST)
Received: from s-koew3-smtp1.koeln.ads.risnet.de
 (s-koew3-smtp1.koeln.ads.risnet.de [10.64.227.203])
	by rewemta03.eil.risnet.de (Switch-3.1.7/Switch-3.1.7) with ESMTP id
 k4F7PgbU010157
	for <poi-user@jakarta.apache.org>; Mon, 15 May 2006 09:25:42 +0200
Received: by s-koew3-smtp1.koeln.ads.risnet.de with Internet Mail Service
 (5.5.2657.72)
	id <K89C3X2S>; Mon, 15 May 2006 09:25:41 +0200
Message-ID: <A5E4B3E29A55D511A2AD0006299976EC0734CF36@KSKoeln3>
From: "Marx,
 Stefan ext. MA Fa. Lynx" <Stefan.Marxext.MAFa.Lynx@rewe-group.com>
To: "'POI Users List'" <poi-user@jakarta.apache.org>
Subject: AW: java.lang.OutOfMemoryError: Java heap space
Date: Mon, 15 May 2006 09:25:41 +0200
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2657.72)
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-TBoneOriginalFrom: "Marx,
 Stefan ext. MA Fa. Lynx" <Stefan.Marxext.MAFa.Lynx@rewe-group.com>
X-TBoneOriginalTo: "'POI Users List'" <poi-user@jakarta.apache.org>
X-TBoneDomainSigned: false
X-Rewe-Scanned: 1
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi guys,

stick to the 2.5 api for several reasons I write my=20
files in tab separated line mode and lose any for-
matting. I've heared rumors that there is a strea-
ming api in coocon didn't take a look at. Anyone
else?

cu && greetings from Cologne, Germany

Stefan

Stefan Marx
Marx Consulting (extern)

REWE GROUP=20
Gesch=E4ftsbereich Konzern-Systeme
Funktionsbereich Business-Systeme

REWE-Informations-Systeme GmbH
Humboldtstra=DFe 140-144 - 51149 K=F6ln

Telefon:  +49 (0)221 149 - 5953
Telefax:  +49 (0)221 149 - 97 5953
E-Mail: Stefan.Marxext.MAFa.Lynx@rewe-group.com
www.rewe-group.com


> -----Urspr=FCngliche Nachricht-----
> Von:	Denis Pimenov [SMTP:king@bitel.ru]
> Gesendet am:	Montag, 15. Mai 2006 09:18
> An:	POI Users List
> Betreff:	Re: java.lang.OutOfMemoryError: Java heap space
>=20
> LiuGuoMing wrote:
>=20
> >Hi,ALL
> >java.lang.OutOfMemoryError: Java heap space
> >
> >
> >I'm currently using POI to generate some fairly large Excel files=20
> >(30,000+ rows), using the org.apache.poi.hssf.usermodel package.=20
> >
> >it occur 'java.lang.OutOfMemoryError: Java heap space' when run it.=20
> >
> > =20
> >
>=20
> >Why?How to solve it?
> >
> > =20
> >
> I have already faced with that problem. And i haven't found solution =
for=20
> it. The trouble is in implementation of java language and poi . Big=20
> excel file consists of great number of little structures and size =
plenty=20
> of them is about 1 - 8 bytes. Poi creates java object for each=20
> structure. Empty java object in sun implementation has size of 8 =
bytes.=20
> An object with 1-byte field is aligned to 16 bytes, 4 - bytes to 16, =
9=20
> bytes to 24 and etc. This lead to that : poi reads a documents with =
size=20
> of 45 Mb(about 3000 000 objects), but poi object has size of 700 Mb.
>=20
> I have solved that problem for reading with using "poi event based =
api"=20
> . I have read only data and placed it in lists. This decreased =
object's=20
> size from 700 to 160.
> But still i don't know solution for file generation. I even think =
that,=20
> may be, poi developers can't help you.
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/