Page 1 of 1

Apache POI 3.6 - ClassPath error in XSSF mode

Posted: Thu Jul 29, 2021 12:41 pm
by jmaple79
New here, so forgive me if this has all been answered once or twice.

I am trying to implement Apache POI and the HssfR4/xlparser software at the small business I work for and I am running into walls.
I am using the Apache POI 3.6 version and trying to stay as close to the instruction that Scott has in his site, in the software, etc.., but I keep getting a classpath issue when running XLCRTDEMO in XSSF mode.

I am learning Java at the same time I am trying to implement this software, so I am not above assuming that I am the idiot in this scenario. :D

Any help would be amazing.

Jason

Re: Apache POI 3.6 - ClassPath error in XSSF mode

Posted: Thu Jul 29, 2021 7:25 pm
by Scott Klement
Hi Jason,

Everyone is new here, I just opened up these forums yesterday :-)

Can you tell us about the problem you're having? The subject line says you're having a CLASSPATH error. Can you post the full error message?

Thanks!

Re: Apache POI 3.6 - ClassPath error in XSSF mode

Posted: Tue Aug 10, 2021 3:37 pm
by jmaple79
Hi Scott,
I ran into a case of, I didn't know what I didn't know. I was able to get the Apache POI 3.6 and Your matching software talking to each other. I have another question though and I will post in a different forum.

Re: Apache POI 3.6 - ClassPath error in XSSF mode

Posted: Fri May 17, 2024 6:27 pm
by HEB768
Hi,
I’m contacting you for the following problem. At my client's site, we are currently using the org.apache.poi.xssf.usermodel.HSSFWorkbook class without problem in a production program. We would like to modify the program to integrate the org.apache.poi.xssf.usermodel.XSSFWorkbook class in order to be able to generate an .xlsx file. I took your example of the HDRDEMO program on your site, making sure I had the correct jars in the CLASSPATH but I still got the following error message:

Note: I have added an attachment the screenshots of the error message, CLASSPATH declared in the program and the jars in the IFS.

Thanks you !

Message ID . . . . . . : RNX0301
Date sent . . . . . . : 24/05/17 Time sent . . . . . . : 13:49:00

Message . . . . : Java exception received when calling Java method.

Cause . . . . . : RPG procedure HDRDEMO in program SIDSB82/HDRDEMO received
Java exception "java.lang.NoClassDefFoundError:
org.apache.poi.ss.usermodel.Date1904Support" when calling method "<init>"
with signature "()V" in class "org.apache.poi.xssf.usermodel.XSSFWorkbook".
Recovery . . . : Contact the person responsible for program maintenance to
determine the cause of the problem.
Technical description . . . . . . . . : If the exception indicates that the.......