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/
Error on XLCRTDEMO
Re: Error on XLCRTDEMO
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 !
Re: Error on XLCRTDEMO
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)
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)
Re: Error on XLCRTDEMO
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.
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.
Re: Error on XLCRTDEMO
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]
[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]
- Attachments
-
- Screenshot 2024-08-07 153544.png (55.74 KiB) Viewed 4065 times
-
- Site Admin
- Posts: 796
- Joined: Sun Jul 04, 2021 5:12 am
Re: Error on XLCRTDEMO
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/
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/