MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2013

RE: Create Excel spreadsheet on iSeries unattended in batch mode



fixed

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.







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