Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 96217 invoked from network); 29 Sep 2004 12:07:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 29 Sep 2004 12:07:09 -0000 Received: (qmail 55701 invoked by uid 500); 29 Sep 2004 12:07:06 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 55506 invoked by uid 500); 29 Sep 2004 12:07:04 -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 55491 invoked by uid 99); 29 Sep 2004 12:07:04 -0000 X-ASF-Spam-Status: No, hits=1.8 required=10.0 tests=DNS_FROM_RFC_POST,FROM_HAS_ULINE_NUMS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from [64.4.31.37] (HELO hotmail.com) (64.4.31.37) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 29 Sep 2004 05:07:02 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 29 Sep 2004 05:07:01 -0700 Received: from 217.40.52.25 by by13fd.bay13.hotmail.msn.com with HTTP; Wed, 29 Sep 2004 12:06:35 GMT X-Originating-IP: [217.40.52.25] X-Originating-Email: [nigel_br0wn@hotmail.com] X-Sender: nigel_br0wn@hotmail.com From: "Nigel Brown" To: poi-user@jakarta.apache.org Bcc: Subject: What do these warnings mean? Date: Wed, 29 Sep 2004 14:06:35 +0200 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 29 Sep 2004 12:07:01.0061 (UTC) FILETIME=[D37BAF50:01C4A61C] X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi, I am currently running a few test to see if I can reuse some excel files which contain data, without having to design a proper database around them. I wrote the following code, which attempts to read the number of sheets from an existing file. code: -------------------------------------------------------------------------------- import java.io.*;import org.apache.poi.hssf.usermodel.*;import org.apache.poi.poifs.filesystem.*; public class Test { public static void main (String []args) throws IOException{ POIFSFileSystem fs = new POIFSFileSystem(New FileInputStream("Test.xls")); HSSFWorkbook wb = new HSSFWorkbook(fs); int i = wb.getNUmberOfSheets(); System.out.println(i); }} -------------------------------------------------------------------------------- The code compiles, but when I run the program I recieve the following warnings [WARNING] Unknown Ptg 69 (105) //repeated four times [WARNING] Unknown Ptg 11 (17) at cell (29,4) //repeated for a few different cells [WARNING] Unknown Ptg 69 (105) at Cell (121,4) // The Ptg 69 warning again this time on a number of different cells. Then eventually I receive a java.lang.OutOfMemoryError and the program exiting. Sorry for the long winded build up to my questions. What are these Warnings, can I find any documentation on them ? How do I prevent them and is there a limit to the size of Excel file I can read ? _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail --------------------------------------------------------------------- To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: poi-user-help@jakarta.apache.org