Mark,
It doesn't have a lot to do with time -- I have no reason to do so. I
no longer write articles about this stuff, so I don't need it for
articles. I haven't had any assignments where generating/reading
spreadsheets would be useful to me in 3 years.
Please understand that this is not a commercial tool that you are paying
support for... I'm happy to help you for free because I enjoy it, but
for me to take the time to put major work into something, I need a
reason to do it... not just "because it would help Mark". Though, that
would be a good reason for Mark to do it, and contribute his work back
to the project :-)
Mainly, updating to a newer POI involves downloading the new JAR files.
They are usually "mostly" backward compatible, but some of the
functions might not work without some tweaks to HSSFR4/XLPARSER4. So
you test out the functions and see what needs to be updated, and make
the updates. Please feel free to do that and contribute the changes
back to me and I'll make them available to everyone.
Back then (3 years ago, when I needed this last) I did write a pure RPG
program that generates Excel spreadsheets, runs more than 60 times
faster than POI, but does not have all the features. The big problem
with this is the .ZIP support that's needed... the APIs built in to IBM
i (as of 7.1) are not capable enough to do the job, so you have to rely
on the 'jar' tool (which I hate) or have to install a PASE zip tool like
InfoZip. I was hoping to find a better (or at least, more native)
solution than that... but never did, and got sidetracked with other things.
None of this has anything to do with Profound Logic or an OA handler.
On 6/25/2015 1:40 PM, Mark Murphy/STAR BASE Consulting Inc. wrote:
Scott, have you had time to upgrade your POI interface to support any version beyond 3.6? The last article I saw is getting a little dated, and I am trying to set something up at my current client. When I went to download POI I noticed it is now at version 3.12 (twelve), I suspect the other jars are getting a bit behind since 2010 as well.
Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx
midrange.com
