Return-Path: 
 <poi-user-return-8560-apmail-jakarta-poi-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org
Received: (qmail 78473 invoked from network); 6 Sep 2006 16:04:07 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 6 Sep 2006 16:04:07 -0000
Received: (qmail 25286 invoked by uid 500); 6 Sep 2006 16:04:05 -0000
Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org
Received: (qmail 25265 invoked by uid 500); 6 Sep 2006 16:04:04 -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 25254 invoked by uid 99); 6 Sep 2006 16:04:04 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Sep 2006 09:04:04 -0700
X-ASF-Spam-Status: No, hits=0.5 required=10.0
	tests=DNS_FROM_RFC_ABUSE,HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of philippe.desrosiers@gmail.com
 designates 66.249.92.168 as permitted sender)
Received: from [66.249.92.168] (HELO ug-out-1314.google.com) (66.249.92.168)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Sep 2006 09:04:03 -0700
Received: by ug-out-1314.google.com with SMTP id m2so2585816uge
        for <poi-user@jakarta.apache.org>;
 Wed, 06 Sep 2006 09:03:42 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:mime-version:content-type;
        b=S5KAKQWEkKhMKvHimwSXwjuzeFhv4iU0/W6OFJaiFQcs7J5sIT643C4XcYwdl5JpL45gIpaZPeCZpKA8IpWAeQEQW3aDxHyIbOibubpdz+3ac0SCIlBXZPtC/hq0XAxdT96zgD/2FPNZp7TWwEBAsQNJEcVGy351gEAUZfupvqU=
Received: by 10.67.100.17 with SMTP id c17mr4496173ugm;
        Wed, 06 Sep 2006 09:03:42 -0700 (PDT)
Received: by 10.67.31.6 with HTTP; Wed, 6 Sep 2006 09:03:42 -0700 (PDT)
Message-ID: <416358290609060903w5bffc8e3gc1e258010e207081@mail.gmail.com>
Date: Wed, 6 Sep 2006 12:03:42 -0400
From: "Philippe DesRosiers" <philippe.desrosiers@gmail.com>
To: poi-user@jakarta.apache.org
Subject: Handling very large Excel files with HSSF?
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_193091_1642524.1157558622465"
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_Part_193091_1642524.1157558622465
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I'm trying to open a very LARGE excel file (around 45 thousand rows, but
only seven or eight columns), but HSSF seems to hang during the creation of
the HSSFWorkbook. Here's some code:

<snip>
            content = new FileInputStream(myFile);
            POIFSFileSystem fs = new POIFSFileSystem(content);
            HSSFWorkbook workbook = new HSSFWorkbook(fs);      //code hangs
on this line.
</snip>

Does anyone have any ideas? Does HSSF just not support large files? What is
the largest file size supported? Can I enable logging in HSSF to get more
information?

thanks,

------=_Part_193091_1642524.1157558622465--