Re: R: Utility for import excel file to db2 file

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi

I no longer can see the systems at my previous job. I do wonder about 
the Java version you are running. The JAR files are not current 
versions, we ran Java 8, as I remember. We had a command to set the Java 
home in a setup CL.

RUNJVA CLASS(*version)

*Regards*

*Vern Hamberg*

<cid:part1.2xhGQ1du.SZdKVYmG@centurylink.net>

On 2/1/2025 5:32 PM, Giovanni Arturi via RPG400-L wrote:
> 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.