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.
Any help would be amazing.
Jason
Apache POI 3.6 - ClassPath error in XSSF mode
-
- Site Admin
- Posts: 795
- Joined: Sun Jul 04, 2021 5:12 am
Re: Apache POI 3.6 - ClassPath error in XSSF mode
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!
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
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.
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
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.......
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 (9.81 KiB) Viewed 6805 times
-
- 2024-05-17_13-50-51.png (42.17 KiB) Viewed 6805 times
-
- 2024-05-17_14-15-44.png (117.45 KiB) Viewed 6805 times