I forgot to say that before run CALL PGM(XLPDEMO) PARM('1') I execute the
command
ADDENVVAR ENVVAR(CLASSPATH)
VALUE('/java/xlparse3.6/xlparse.jar
:/java/poi3.6/poi-3.6-20091214.jar
:/java/poi3.6/poi-ooxml-3.6-20091214.jar
:/java/poi3.6/poi-ooxml-schemas-3.6-20091214.jar
:/java/dom4j/dom4j-1.6.1.jar
:/java/xmlbeans/jsr173_1.0_api.jar
:/java/xmlbeans/xbean.jar')
LEVEL(*JOB)
REPLACE(*YES)
-----Messaggio originale-----
Da: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> Per conto di gio.cot via
RPG400-L
Inviato: domenica 2 febbraio 2025 00:10
A: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: gio.cot <gio.cot@xxxxxxxxxxx>
Oggetto: R: Utility for import excel file to db2 file
Hi Vern
I installed Scott's POI utility
When i try to run CALL PGM(XLPDEMO) PARM('1') i receive this error
Message ID . . . . . : RNX0301
Date sent. . . . . . : 02/02/25 Sending time. . . . . . : 00:01:43
Message . . . : Received Java exception in Java method call.
Cause . . . . . : The XLPARSE_WO RPG procedure in the program
XLPARSE36/XLPARSER4 received a Java exception
"java.lang.NoClassDefFoundError:
com.iseriesnetwork.clubtech.xlparse.ParseSheetXssf" in the method call
"parse" with signature "([B)V" in the class
"com.iseriesnetwork.clubtech.xlparse.ParseSheetXssf".
Here the /java content:
dom4j
jdbc
poi3.2
poi3.6
xlparse3.2
xlparse3.6
xmlbeans
where am i wrong ? what i could check ?
Thanks in advance
+1 on Scott's POI utility (service program). At my previous position we
used it to read XLSX spreadsheets, then you can do whatever you want with
the values. Very easy to use.
As an Amazon Associate we earn from qualifying purchases.