Re: Windows batch-file-friendly command to automatically convert Excel to XML

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