scottklement.com

XLCRTDEMO doesn't use xlparse.jar...

but if you want a copy, you can find it (together with the source for XLPARSER4 which uses it) here:
https://www.scottklement.com/poi/

wdwisser wrote: Fri Apr 29, 2022 11:52 am I didn't have my java path setup correctly. I had a friend help me out and now it works just fine... my mistake from learning as I go.

Hi, I have the same problem that you have.
Cause . . . . . : RPG procedure XLCRTDEMO in program POI36/XLCRTDEMO
received Java exception "java.lang.NoClassDefFoundError: org.apache.poi.xssf.usermodel.XSSFWorkbook" when calling method "<init>" with signature "()V" in class "org.apache.poi.xssf.usermodel.XSSFWorkbook".

I saw that you resolved your problem with you path Class. Can you share your path to see and compare with my code. Thank you !

This is the CLASSPATH I am currently using, and it seems to work just fine.

ADDENVVAR ENVVAR(CLASSPATH) +
VALUE('/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/xmlbeans-2.5.0.jar') +
LEVEL(*JOB) +
REPLACE(*YES)

Hi

Thank you for your help. It's working now. I missed the xmlbeans-2.5.0 jar on my CLASSPATH and now everything is ok.

Where did you get all these jar file. I am getting jar files as you can find in attachment. would it be same or not?

[img][/img]
ADDENVVAR ENVVAR(CLASSPATH) +
VALUE('/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/xmlbeans-2.5.0.jar') +
LEVEL(*JOB) +
REPLACE(*YES)[/b]

I wrote this stuff for a previous job many years ago. If you want to take the code and update it to work with 5.3.0 you certainly can, but it'll be up to you to identify the things that need to be change, change them, test them, etc.

I know it works with version 3.8.

You should be able to get any release from the POI website... I just went there now and clicked through and it took me to this URL. It looks like it has the poi-bin-3.8 (and poi-bin.3.6 versions) amongst other things...
https://archive.apache.org/dist/poi/release/bin/