RE: Using POI Java Classes

["Haas, Matt" <Matt.Haas@xxxxxxxxxxx>]

Mark,

If you're opening the file with Excel 2003 and saving it after it's been
created, that may be your problem. POI only works with certain versions
of Excel. The versions it works with are documented on the POI website.

Of course, one of the problems you're having is that you're not getting
the reason why the exception was triggered (in Java, you can call the
getMessage method on the exception to get the reason). I'm not sure if
you can get that or not when calling Java classes from RPG (there may be
something in the archives about this).

Matt 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
MWalter@xxxxxxxxxxxxxxx
Sent: Wednesday, June 01, 2005 4:05 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Using POI Java Classes

With which versions of Excel are you folks using these classes. I'm
still
getting this error:

                         Additional Message Information
 Message ID . . . . . . :   RNX0301       Severity . . . . . . . :   50
 Message type . . . . . :   Escape
 Date sent  . . . . . . :   06/01/05      Time sent  . . . . . . :
15:56:38
 Message . . . . :   Java exception received when calling Java method.
 Cause . . . . . :   RPG procedure HSSF_OPEN in program JAVALIB/HSSFSVC
   received Java exception "java.io.IOException:" when calling method
"<init>"
   with signature "(Ljava.io.InputStream;)V" in class
   "org.apache.poi.poifs.filesystem.POIFSFileSystem".
 Recovery  . . . :   Contact the person responsible for program
maintenance
to
   determine the cause of the problem.
 Technical description . . . . . . . . :   If the exception indicates
that
the
   Java class was not found, ensure the class for the method is in the
class
   path. If the exception indicates that the Java method was not found,
check
   the method name and signature. If the signature is not correct,
change
the
   RPG prototype for the method, or change the Java method, so that the
return

More...
 Press Enter to continue.

When I try to open a spreadsheet from within a job that didn't create
the
spreadsheet.  I'm wondering if it's because I may be opening the
workbook
and saving it as it's closed.

I'm using Excel 2003.

Thanks,

Mark
<snip>