IBM's i Access Client Solutions, the Java version of IBM i Access features,
can be uploaded to and run on the IBM i.

It provides the Data Transfer components (file download / upload). You can
run the rudimentary data transfers on the IBM i, the same as you can on a PC
using the Data Transfer programs. You can export to an Excel file, CSV, and
other files types that are supported by the Data Transfer program. Under the
covers, the IBM i Access Data Transfer uses the POI code that is used in
Scott's code. The downside of the Data Transfer approach is that it does not
support any customization of the resulting Excel file, just simple headers
with rows/columns.

On the other hand, this could provide a "no programming" approach that can
be easily automated.

Some information is in these articles:
(updated version of article, behind pay-wall)

Craig Pelkie

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steinmetz, Paul
Sent: Thursday, December 19, 2013 7:05 AM
To: 'Midrange Systems Technical Discussion'
Subject: Create Excel spreadsheet on iSeries unattended in batch mode

Create Excel spreadsheet on iSeries unattended in batch mode Is there a tool
or API to do this.

Thank You
Paul Steinmetz
IBM i Systems Administrator

Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071

610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home


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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at

This thread ...


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

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