Error on XLCRTDEMO

Scott Klement's open source interface to the POI HSSF/XSSF Spreadsheet Project for RPG Programmers. http://www.scottklement.com/poi/
Scott Klement
Site Admin
Posts: 796
Joined: Sun Jul 04, 2021 5:12 am

Re: Error on XLCRTDEMO

Post by Scott Klement »

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/
HEB768
Posts: 6
Joined: Thu May 16, 2024 7:04 pm

Re: Error on XLCRTDEMO

Post by HEB768 »

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 !
wdwisser
Posts: 31
Joined: Tue Feb 15, 2022 5:12 pm

Re: Error on XLCRTDEMO

Post by wdwisser »

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)
HEB768
Posts: 6
Joined: Thu May 16, 2024 7:04 pm

Re: Error on XLCRTDEMO

Post by HEB768 »

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.
Badetia
Posts: 1
Joined: Wed Aug 07, 2024 9:58 am

Re: Error on XLCRTDEMO

Post by Badetia »

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

Re: Error on XLCRTDEMO

Post by Scott Klement »

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/
Post Reply