RE: Output from PF to Excel XLS file in IFS

[meovino@xxxxxxxxxxxxxxxxx]

Wow!  Are those prices for real?  I know this probably can't do 1/10 of
what SEQUEL can, but it looks like it will do the 1/10 I need.  Thanks!

Mike E.




                                                                                
                                          
                    "Leland, David"                                             
                                          
                    <dleland@Harter.com>        To:     "'Midrange Systems 
Technical Discussion'"                         
                    Sent by:                     <midrange-l@midrange.com>      
                                          
                    midrange-l-bounces@mi       cc:                             
                                          
                    drange.com                  Subject:     RE: Output from PF 
to Excel XLS file in IFS                  
                                                                                
                                          
                                                                                
                                          
                    02/07/03 10:32 AM                                           
                                          
                    Please respond to                                           
                                          
                    Midrange Systems                                            
                                          
                    Technical Discussion                                        
                                          
                                                                                
                                          
                                                                                
                                          




We use an inexpensive package from KemeTech System that does exactly that -
www.kemetech.com.  I just chuckle to myself when I read all the posts about
people who want to "roll-their-own" or who are creating CSV files using
CPYTOIMPF, and then complain about the quality of the resulting file, when
there are inexpensive packages that actually create an XLS file, complete
with headers and simple formulas (=SUM, =AVG, etc.).

Dave

-----Original Message-----
From: meovino@estes-express.com [mailto:meovino@estes-express.com]
Sent: Friday, February 07, 2003 9:57 AM
To: midrange-l@midrange.com
Subject: Output from PF to Excel XLS file in IFS


Does anyone know of any packages out there that will allow you to create
XLS files from PF's?  CSV won't work here, the user absolutely, positively
will not accept anything but an honest-to-god XLS file.  And we want to
generate and e-mail the XLS file with no user intervention, so the package
would need a command interface.

I know about SEQUEL, but my boss thinks it's too pricey.  I'm working on
learning Java, so I once I feel comfortable with it, I suppose I could use
HSSF, but I'm going to scare people if I make them call Java programs from
RPG.

Mike E.