poi hssf question -- RPG400-L

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

Does anyone know what might be the reason for getting the followingexception when trying to open an existing MS Excel file while using poiHSSF?:

java.io.IOExceptionjava/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/InputStream;)V+18(HeaderBlockReader.java:71)

I'm actually using Scott Klement's HSSFR4 service program. The codethat 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

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.