× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



You can upgrade to POI 3.14 and all will work fine.

POI 3.15 has the start of changes to using enums which requires
modification to the classes/calls.

Here is a couple of comments that are in the archive;

POI 3.15 refactored some constants to Enums so is mildly incompatible with
Scotts header files.
POI tests run for Java 6, 8, and 9. Apparently Java 7 is close enough to
Java 6 that they don't see any reason to test with it.


HTH


Don




From: "Vernon Hamberg" <vhamberg@xxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Date: 14/10/2020 12:47 AM
Subject: Re: Latest POI version and what do I need to know
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>



We are at 7.3, so maybe not exactly the same as you will be -- but we
are using POI 3.9 with no issues. We use the default JVM - I expect that
7.4 would still support the 7.3 default - that needs to be verified.

Here are the results from running java -version in QShell -

java version "1.8.0_231"
Java(TM) SE Runtime Environment (build 8.0.6.0 -
pap3280sr6-20191107_01(SR6))
IBM J9 VM (build 2.9, JRE 1.8.0 OS/400 ppc-32-Bit 20191106_432135 (JIT
enabled, AOT enabled)

We have 5770JV1 options 14, 16, & 17.

I do remember testing the several Java versions on our system and found
no problems with any of that, as I recall.

We have the following setup for the CLASSPATH environment variable -

/java/poi3.9/poi-3.9-20121203.jar
/java/poi3.9/poi-ooxml-3.9-20121203.jar
/java/poi3.9/poi-ooxml-schemas-3.9-20121203.jar
/java/dom4j/dom4j-1.6.1.jar
/java/xmlbeans/xmlbeans-2.6.0/jsr173_1.0_api.jar
/java/xmlbeans/xmlbeans-2.6.0/xbean.jar
/java/xmlbeans/xmlbeans-2.6.0/xmlbeans-qname.jar

HTH
Vern

On 10/13/2020 9:21 AM, a4g atl wrote:
We are upgrading from v7.2 to V7.4. Our test system is now at v7.4.

We have a few programs using the POI 3.6 classes.

What versions of POI is recommended?
What Gotcha's do I need to be aware of?
What is the latest version of Java available for the i?
Should I look at another tool?

TIA
Darryl Freinkel


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2024 by midrange.com 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.