RE: poi hssf question

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