× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I ran it using an earlier version (Excel 5.0/95) and still get the same exception.

Matt.Haas@xxxxxxxxxxx wrote:

If you're using the latest version of the Excel format, you'll get this
error. I don't think POI works with anything newer than Excel 2000.

Matt
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jose Santana
Sent: Tuesday, January 17, 2006 9:45 AM
To: RPG400-L@xxxxxxxxxxxx
Subject: poi hssf question

Does anyone know what might be the reason for getting the following exception when trying to open an existing MS Excel file while using poi HSSF?:

java.io.IOException


java/lang/Throwable.<init>()V+4 (Throwable.java:73)


java/lang/Exception.<init>()V+1 (Exception.java:24)


java/io/IOException.<init>()V+1 (IOException.java:26)


java/io/FileInputStream.readBytes([BII)I+?? (FileInputStream.java:??) java/io/FileInputStream.read([BII)I+1 (FileInputStream.java:179) org/apache/poi/util/IOUtils.readFully(Ljava/io/InputStream;[BII)I+13 (IOUtils.java:51) org/apache/poi/util/IOUtils.readFully(Ljava/io/InputStream;[B)I+5 (IOUtils.java:36) org/apache/poi/poifs/storage/HeaderBlockReader.<init>(Ljava/io/InputStre am;)V+18 (HeaderBlockReader.java:71)

I'm actually using Scott Klement's HSSFR4 service program. The code that calls the open function is:

D FileName s 32A :
:
 book = hssf_open(%trim(FileName));

The exception is thrown at following line in hssf_open:

wwBook  = new_HSSFWorkbookFromPOIFS(wwPOIFS);

If anyone can help I'd greatly appreciate it.

Jose




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.