Re: poi hssf question

[Jose Santana <jsantana@xxxxxxxxxxxxx>]

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
>
>