RE: Output from PF to Excel XLS file in IFS

Scott, just as an alternative you could probably add these hooks into rpg
iv, to call these java classes...
http://jakarta.apache.org/poi/hssf/quick-guide.html

tim


> -----Original Message-----
> From: Scott Klement [SMTP:klemscot@klements.com]
> Sent: Friday, February 07, 2003 11:49 AM
> To:   Midrange Systems Technical Discussion
> Subject:      RE: Output from PF to Excel XLS file in IFS
> 
> 
> There's a big difference between CSV and XLS, even if Excel does open them
> both...   There's a TON of things you can't do in CSV...  such as how
> columns & rows are formatted, fonts, formulas, macros, etc...
> 
> I keep thinking about creating an RPG IV service program for generation
> spreadsheets (along the lines of the Spreadsheet::WriteExcel package for
> perl, except that it would run natively on the iSeries) but I always seem
> to have something more important and/or urgent to do.
> 
> 
> 
> On Fri, 7 Feb 2003, Dennis Lovelady wrote:
> >
> > Wouldn't it be simpler to just change the Winblows file association for
> > .CSV to open EXCEL?  Or is that too simplistic?
> >
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.