Apache POI 3.6 - ClassPath error in XSSF mode

Scott Klement's open source interface to the POI HSSF/XSSF Spreadsheet Project for RPG Programmers. http://www.scottklement.com/poi/
Post Reply
jmaple79
Posts: 10
Joined: Thu Jul 29, 2021 12:27 pm

Apache POI 3.6 - ClassPath error in XSSF mode

Post 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
Scott Klement
Site Admin
Posts: 697
Joined: Sun Jul 04, 2021 5:12 am

Re: Apache POI 3.6 - ClassPath error in XSSF mode

Post 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!
jmaple79
Posts: 10
Joined: Thu Jul 29, 2021 12:27 pm

Re: Apache POI 3.6 - ClassPath error in XSSF mode

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

Re: Apache POI 3.6 - ClassPath error in XSSF mode

Post 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.......
Attachments
2024-05-17_13-50-16.png
2024-05-17_13-50-16.png (9.81 KiB) Viewed 3453 times
2024-05-17_13-50-51.png
2024-05-17_13-50-51.png (42.17 KiB) Viewed 3453 times
2024-05-17_14-15-44.png
2024-05-17_14-15-44.png (117.45 KiB) Viewed 3453 times
Post Reply