MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2012

Re: Convert PF to Excel in batch



fixed

Besides commercial products, there's Scott's HSSF stuff (RPG hooks
into POI), straight Apache POI, and JExcelAPI.

Takes some coding, but there are bunches of examples out there.

On Fri, Sep 14, 2012 at 9:30 AM, Tim Adair <tadair@xxxxxxxxxxxxxxxx> wrote:
Is there a simple (cheap/free) utility to convert a PF to a true Excel file
(not CSV - customer requirement) in batch, and put it in the IFS? This
needs to run with no intervention.

Something like:

CVTPF2EXCEL file(library/file) path('/home/whatever/')


I've researched it and can't seem to find anything that fits the bill.
System i Access transfers won't work. If I had the time I could look into
writing it myself, but I don't. This seems basic enough that surely ("Don't
ever call me Shirley") someone must have needed this in the past.

Any ideas? Thanks in advance for any and all responses.


~TA~

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact