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



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/


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.