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: 732
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.
Post Reply