Thanks, but I was already used to this from experience with SQL2XLS. So
I've been logging off and back on every time I do anything. Also tried
running in batch vs. interactive, which also seems to affect these HSSF
things strangely.
I did find another archive which mentioned an error in Scott's HSSF_Open
procedure, where wwFile was defined as being like jFileOutputStream when
it should be jFileInputStream. I fixed that, but still no joy.
G
|-----Original Message-----
|From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-
|bounces@xxxxxxxxxxxx] On Behalf Of DLee@xxxxxxxx
|Sent: Wednesday, November 28, 2007 4:41 PM
|To: rpg400-l@xxxxxxxxxxxx
|Subject: Java error when updating existing Excel spreadsheets using
HSSF
|
|Greg
|
|<Cause . . . . . : RPG procedure HSSF_OPEN in program GNODGDF/HSSFR4
|received Java exception "java.lang.NoClassDefFoundError:>
|
|Don't know if your situation is the same as errors I've had with
|HSSF_OPEN
|failure. I have had this when I previously had another error running
an
|hssf job.
|
|I found my cure to solve this is to sign off, and sign back on. The
|error gets cleared. And everything runs fine.
|
|I understand this is the only way to clear up that error.
|
|Hope this works for you
|
|Darrell Lee
|Information Technology
|Extension 7127
|--
|This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
|list
|To post a message email: RPG400-L@xxxxxxxxxxxx
|To subscribe, unsubscribe, or change list options,
|visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
|or email: RPG400-L-request@xxxxxxxxxxxx
|Before posting, please take a moment to review the archives
|at
http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.