We use extensively a home grown small utility (CPY2CSVF) that receives a
extracts it's columns headers and data and creates a .csv file in
a specified directory,
net or IFS.
(it's done simply by calling CPYTOIMPF with some prior processing)
the utility then either calls MS Excel to open the csv file on the user's
PC using simple
STRPCO or e-mails the .csv file using SNDDST. (in case of batch)
Does any of you guys know of a tool (preferably free) to convert the A/M
file to Excel proper? and a AS400 native (PASE) tool at that?
I would very much like to extend this tool and create xls(x) files.
I know it's a tall order but it just may be my lucky day...
a. POI is not my cup of tea.
b. I found some command line Windows converters, wonder if there are
This mailing list archive is Copyright 1997-2013 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