Re: HSSF error when reading an existing Excel spreadsheet

Rich,

Man, that stinks...and here I thought I'd finally get to help someone...

Shane




"Rich Dotson" <rich_dotson@xxxxxxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
10/11/2005 10:22 AM
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
java400-l@xxxxxxxxxxxx
cc

Subject
Re: HSSF error when reading an existing Excel spreadsheet






Shane,

No luck.   I received the same error as before.

Thanks for the suggestion though...

----Original Message Follows----
From: Shane_Cessna@xxxxxxx
Reply-To: Java Programming on and around the iSeries / 
AS400<java400-l@xxxxxxxxxxxx>
To: Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>
Subject: Re: HSSF error when reading an existing Excel spreadsheet
Date: Tue, 11 Oct 2005 08:32:13 -0500

Rich,

I have an idea...not sure if this is right or not but here goes...

before you call this program try changing your current directory to the
directory where the XLWorkBook.java file is...

CHGCURDIR DIR('/QIBM/UserData/Java400/ext/')...or where ever you put the
java file...

see if that works...

Shane Cessna
iSeries Programmer
iSeries WAS Administrator
North American Lighting, Inc.
(618) 662-4483 x2776
shane_cessna@xxxxxxx



"Rich Dotson" <rich_dotson@xxxxxxxxxxx>
Sent by: java400-l-bounces@xxxxxxxxxxxx
10/11/2005 08:16 AM
Please respond to
Java Programming on and around the iSeries / AS400
<java400-l@xxxxxxxxxxxx>


To
java400-l@xxxxxxxxxxxx
cc

Subject
Re: HSSF error when reading an existing Excel spreadsheet






Shane,

I changed the CLASSPATH and was able to compile the XLWorkBook.java
program.
    I added the openXL procedure to my RPG program just as you described 
in

the previous email.  Now when I run the RPG program I get the following
error:

Message ID . . . . . . :   RNX0301       Severity . . . . . . . :   50
Message type . . . . . :   Diagnostic
Date sent  . . . . . . :   10/11/05      Time sent  . . . . . . : 09:00:30

Message . . . . :   Java exception received when calling Java method.
Cause . . . . . :   RPG procedure XLSOPEN in program U28871/XLSOPEN
received
    Java exception "java.lang.UnsatisfiedLinkError:" when calling method
"load"
    with signature "" in class "XLWorkBook".

The error occurred on line 50 below:

49         fileName = new_String('/excel/BBNExpress.xls');
50         book = openXL(fileName);


Thanks for all the help....

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 

http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/