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


  1.  Home
  2. MIDRANGE-L
  3. June 2006

Re: Getting a file to excel

Hi Steve
There are the various solutions others have given. Some are free or cheap development kits, like the POI thing, etc., for Java. Of course, your time is worth something, often a lot. Then there are software packages. <blatant vendor response> We at RJS Software have a pretty good one called DataExport/400 - I enhanced the SYLK option so it does a very nice job (if I do say so myself!!!) converting a data file or SQL SELECT into SYLK format, which has much more flexibility than CSV. We also have a product called RPG2SQL that lets you write directly to an Excel spreadsheet almost as if you were working with native files. The product also does SQL stuff, but this is using native OLE automation for the Excel stuff. Take a look at www.rjssoftware.com for more info.</blatant vendor response> 

Vern (vern@xxxxxxxxxxxxxxx)

At 08:16 AM 6/28/2006, you wrote:


HI What are some of the methods in taking a file that was generated by an
RPG program and getting it to the user in an Excel Worksheet file?

It seems to be a straightforward file. Is there a preferred method. Any
issues w/ v5.3 and the client access ?

Thanks,
Steve
--
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.