Use the newer POI 3.12, it is completely compatible with V7.1 using Java 1.6.26 JVM (and likely later). You don't need any supplemental jars. Here is my classpath:

ADDENVVAR ENVVAR(CLASSPATH) +
VALUE('+
/java/poi-3.12/poi-3.12-20150511.jar:+
/java/poi-3.12/poi-ooxml-3.12-20150511.jar:+
/java/poi-3.12/poi-ooxml-schemas-3.12-20150511.jar:+
/java/poi-3.12/lib/commons-codec-1.9.jar:+
/java/poi-3.12/lib/commons-logging-1.1.3.jar:+
/java/poi-3.12/lib/log4j-1.2.17.jar:+
/java/poi-3.12/ooxml-lib/xmlbeans-2.6.0.jar:+
/java/xlparse36/xlparse.jar:+
/java/javamail/javax.mail.jar:+
/java/rpgmail/rpgmail.jar:+
') LEVEL(*JOB) REPLACE(*YES)

the /java/poi-3.12/* jars are in the POI distribution, xlparse comes from Scott, javamail is from Oracle, and rpgmail is from Aaron Bartel. Those last two I use to send my spreadsheets out via email.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----"Englander, Douglas" <Douglas_Englander@xxxxxxxxxxxxx> wrote: -----
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
From: "Englander, Douglas" <Douglas_Englander@xxxxxxxxxxxxx>
Date: 09/10/2015 02:29PM
Subject: POI 3.6

I am have installed the POI 3.6 release from Scott Klement and have also located the Java JAR files he mentions in his article. My question is: The only version of "XMLBEANS 2.5.0 or higher" I can find is XMLBEANS-2.6.0.jar. Does anyone know if XMLBEANS-2.6.0.jar is the same as xbean.jar? I am not sure where the XBEAN.JAR fits in with this. When I unzip XMLBEANS-2.6.0.zip, I do not see anything named xbean.jar

Does anyone know anything about these downloads who could help me locating XBEAN.JAR?

Thank you,

Doug


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-2022 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.