After POI 3.14 they changed the classes to use enums.

We still use 3.14 and all works fine.

When time permits I will have to try and modify the classes to use enums
and be able to use the later versions of POI



From: "DEnglander--- via RPG400-L" <rpg400-l@xxxxxxxxxxxxxxxxxx>
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Cc: DEnglander@xxxxxxxxxxxxxxx
Date: 27/05/2023 08:59 AM
Subject: POI 5.2.3
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx>

Has anyone downloaded POI 5.2.3? I have downloaded the binary, unzipped
it, and copied the JAR files to a folder on the IFS.

I have a program that runs with POI 3.12.

I have a statement in the program that creates a new XLSX workbook: h_book

= new_xssfworkbook();

That line is failing with [when using POI 5.2.3 only, it does not fail
using POI 3.12]:
...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"

My feeling is that something has changed in the spelling of the class, and

that is why it can't be found. However, I have looked through a lot of
posts on the internet and all refer to not having the poi-ooxml-5.2.3.jar
file in the CLASSPATH, but it is there.

If I knew what to change I could probably do it. Or, if I had a way to
look in the source to see what the new version calls this class, I could
probably muddle through and get it to work.

Any ideas?

Thank you,


Douglas Englander
Senior Programmer/Analyst
The C. D. Hartnett Company ? Corporate Offices
1-817-594-3813 ext. 1636

"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments
accompanying it) contain confidential information belonging to the sender.
The information is intended only for the use of the intended recipient.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution or the taking of any action in reliance
on the contents of the information is strictly prohibited. Any
unauthorized interception of this transmission is illegal under the law.
If you have received this transmission in error, please promptly notify
the sender by reply e-mail, and then destroy all copies of the

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2023 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.