RE: poi hssf question

Could be, and the next release Office 2006, is supposed to support XML file
format. So as people start to move to that release, this POI thing will
evaporate, hopefully, and people can just write code that generates XML
instead of the XLS file itself.

There's already a whole lot of that available anyway without the XLS format,
such as HTML import capabilities and the fact that you can embed Excel
functions directly into comma separate values files.  So unless you need
something really critical to the XLS format itself, loading POI may not
strictly be necessary.

-Bob Cozzi
www.RPGxTools.com
RPG xTools - Enjoy programming again.


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Matt.Haas@xxxxxxxxxxx
Sent: Tuesday, January 17, 2006 8:55 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: 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