Re: POI 3.6

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