Re: Getting a file to excel

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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.