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:
http://iprodeveloper.com/systems-management/run-access-client-solutions-data
-transfers-ibm-i
http://iprodeveloper.com/application-development/run-ibm-i-access-client-sol
utions-data-transfers-ibm-i
(updated version of article, behind pay-wall)
http://www.web400.com/downloads/ACS/RunIBMiAccessClientDataXfers.pdf
(instructions)
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
psteinmetz@xxxxxxxxxx
http://www.pencor.com/
--
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.
midrange.com
