RE: Writing to Microsoft Excel format directly, without using CPYTOIMPF

Eric,

Yet another option is to use CGIDEV2 to create XML based Excel files.

Here is an article by Paul Tuohy on the subject. http://www.itjungle.com/fhg/fhg081308-story01.html

Brian May
IBM i Modernization Specialist
Profound Logic Software
http://www.profoundlogic.com
937-439-7925 Phone
877-224-7768 Toll Free


              



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Thursday, June 21, 2012 2:56 PM
To: Midrange Systems Technical Discussion
Subject: Re: Writing to Microsoft Excel format directly, without using CPYTOIMPF

Eric

<verndor response>
In addition to the POI solutions that Scott has given us, our RPG2SQL Integrator product can do this nicely from ILE RPG programs. It makes a connection, basically, to an instance of Excel that lets us do almost anything you can do in the application.

888.rjs.soft is the toll-free access point - ask for me or Rich or sales for more info and/or a quick demo.
</verndor response>

Jon Paris has also written some on using an OAR handler to do this with native IO opcodes - pretty neat.

Vern

On 6/21/2012 2:02 PM, elehti@xxxxxxxxxxxxxxxxxx wrote:

Rob Berendt, you recommended writing to Excel format directly,
without CPYTOIMPF.
Please explain more! Eric

--
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.