Some notes:
poi-ooxml-schemas is a subset of ooxml-schemas, and having both in the classpath has caused some folks issues.
poi-scratchpad is only necessary for binary word, powerpoint, outlook, and visio formats. poi-excelant is for development and testing (provides some test plugins for Ant).
dom4j has not been needed since POI v3.9.
stax-api is not used by the POI project.
Other interesting tidbits concerning POI
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.
Mark Murphy
Atlas Data Systems
mmurphy@xxxxxxxxxxxxxxx
-----Darren Strong <darren@xxxxxxxxx> wrote: -----
To: "RPG programming on the IBM i \(AS/400 and iSeries\)" <rpg400-l@xxxxxxxxxxxx>
From: Darren Strong <darren@xxxxxxxxx>
Date: 01/31/2017 01:51PM
Subject: Re: XSSF/HSSF POI requirements on ibm i 7.3
This is what we have in our default path. I can't recall if "stax-api" and
"dom4j" is necessary, but we have it, so I thought I'd include it.
ooxml-schemas-1.3.jar
ooxml-security-1.1.jar
poi-excelant-3.14--20160307.jar
poi-ooxml-schemas-3.14-20160307.jar
poi-ooxml-3.14-20160307.jar
poi-scratchpad-3.14-20160307.jar
poi-3.14-20160307.jar
dom4j-1.6.1.jar
stax-api-1.0.1.jar
xmlbeans-2.6.0.jar
___________________________________
Darren Strong
Dekko
From: Stefan Tageson <Stefan.Tageson@xxxxxxxx>
To: "RPG programming on the i / System IBM, i" <rpg400-l@xxxxxxxxxxxx>
Date: 01/31/2017 12:47 PM
Subject: Re: XSSF/HSSF POI requirements on ibm i 7.3
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>
Hi Darren, can you please tell me exactly what files are required? I tried
poi 3.15 with no luck. Thank you for your time and cooperation.
Stefan,
Sent from a stupid smartphone, excuse my brevity.
---- Darren Strong wrote ----
We run JDK 8 64 bit and we're running poi-3.14.
Things work well. With the 64 bit JVM, you can up the max. heap size to
handle larger spreadsheets if necessary, using an environment variable as
shown below:
callp(e) QCMDEXC('ADDENVVAR ENVVAR(QIBM_RPG_JAVA_PROPERTIES)
VALUE('
+apos+ '-Xmx8192m;-Xms512m;'+apos+')':1024);
___________________________________
Darren Strong
Dekko
From: Stefan Tageson <Stefan.Tageson@xxxxxxxx>
To: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>
Date: 01/31/2017 08:19 AM
Subject: XSSF/HSSF POI requirements on ibm i 7.3
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>
Hi,
Anyone using Scott Klements POI-routines on ibm i version 7.3 and can
share some information on what jar-files are needed to get a working
environment?
According to the documentation java version 7 is required on ibm 7.3.
Thank you for any hints.
Best regards
Stefan Tageson
Operations West
stefan.tageson@xxxxxxxx<mailto:stefan.tageson@xxxxxxxx>
M +46 732 369934
[cid:image001.png@01CFE8D0.94977830]
evry.com<
http://www.evry.com/>
_________________________
EVRY
Visiting address: Västra Varvsgatan 19
SE-211 19 Malmö, Sweden
Follow us on Twitter<
https://twitter.com/EVRY_se> | Facebook<
https://www.facebook.com/EVRYSverige?fref=ts> | LinkedIn<
http://www.linkedin.com/company/evry-sverige>
EVRY is a leading IT company in the Nordic region. Through advice,
technology and solutions, EVRY brings information to life, creating value
for our customers' business to the benefit of society. With a combination
of extensive industry experience and a customer centric approach, as well
as international capabilities and local presence, we help customers
realise the full potential of IT.
This message contains information which may be confidential and
privileged. Unless you are the intended recipient (or authorized to
receive this message for the intended recipient), you may not use, copy,
print, disseminate or disclose to anyone the message, the attachments here
to or any information contained in the message. If you have received the
message in error, please advise the sender by reply e-mail, and delete the
message with any attachments.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
http://amzn.to/2dEadiD
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
http://amzn.to/2dEadiD
midrange.com
