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.
midrange.com
