×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
midrange.com
