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
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)
[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.
IBM i Systems Administrator
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
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 http://archive.midrange.com/midrange-l