You may want to consider Excel automation, using Visual Basic (built into
Excel). It may be an easier path than trying to use POI/Java.

http://support.microsoft.com/kb/219151

Craig Pelkie

-----Original Message-----
From: PcTech [mailto:pctech-bounces@xxxxxxxxxxxx] On Behalf Of Alan Cassidy
Sent: Wednesday, May 07, 2014 2:04 PM
To: PC Technical Discussion for IBM i (AS/400 and iSeries) Users
Subject: Re: [PCTECH] Windows batch-file-friendly command to automatically
convert Excel to XML

Thanks for the encouragement, Buck.

I am "continuing the momentum", such as it is, with some independent study
on various things that are also on the PC, that will be one of them. Didn't
get into those POI classes at all really before the brick wall hit.

I'm going to look at parsing the data from the XML version of the file from
IFS. Looks like it'll work that way. Between tonight and the weekend I'll
also look at using the XML-INTO op code. Haven't used it yet, looks good.

Alan




-----Original Message-----
From: PcTech [mailto:pctech-bounces@xxxxxxxxxxxx] On Behalf Of Buck Calabro

On 5/6/2014 5:07 PM, Alan Cassidy wrote:
I recently posted to the Midrange and RPG list, about the tools available
for reading from an Excel file using the Java classes from POI-HSSF or XSSF.


However, when I asked about contacting the sys-admin, which is a 3rd
party vendor that handles those duties, and implementing this, there was
blowback about it, mostly because apparently I would be the only one able to
support it, and what if (blank) happens to you, or you leave, or something.
I don't think the other RPG programmer here has much interest, really, or
maybe it's something else.

...because as we all know, RPG source code can be very difficult for RPG
programmers to maintain. Yep, there's something else going on.

There's not much to do then, because (1) the officially titled IT Director
here is not technical, and will not have the position after a move to the
parent HQ in days, and the new CIO there (the new boss of my boss to be) is
reorganizing everything and he hinted in my get-to-know-you interview that
the "AS/400" is a machine that you can set up and when you stabilize your
applications on it it runs forever (and other high praise), but they're
looking at what options they have for the future.

And the VP of Development was real glad I would gladly adapt to any other
technology. (Another clear hint). And by the way, it's a dot-net shop.

(Sigh)
:)

So now I need either auto-conversion Windows command or they'll have to
open, and save-as to a share directory on the IFS. Function probably going
away in a few months anyway. No wonder they figure I might not last.

If you've done any work researching the POI classes you can keep the
momentum going by using those classes - in Java, on the PC. There are a
boatload of examples on the net.

Otherwise, there might be a third party product they'd be willing to pay
for. Who knows?
--buck
--
This is the PC Technical Discussion for IBM i (AS/400 and iSeries) Users
(PcTech) mailing list To post a message email: PcTech@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/pctech.

----------------------------------------------------------------------------
----
Confidentiality Notice: This email may contain confidential information or
information covered under the Privacy Act, 5 USC 552(a), and/or the Health
Insurance Portability and Accountability Act (PL 104-191) and its various
implementing regulations and must be protected in accordance with those
provisions. It contains information that is legally privileged, confidential
or otherwise protected from use or disclosure. This e-mail message,
including any attachments, is for the sole use of the intended recipient(s).
Any unauthorized review, use, disclosure or distribution is prohibited. You,
the recipient, are obligated to maintain it in a safe, secure and
confidential manner. If you are not the intended recipient, please contact
the sender by reply e-mail and destroy all copies of the original message.
Thank you.
----------------------------------------------------------------------------
----


--
This is the PC Technical Discussion for IBM i (AS/400 and iSeries) Users
(PcTech) mailing list To post a message email: PcTech@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/pctech.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2021 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.