Re: Output from PF to Excel XLS file in IFS

[MWalter@xxxxxxxxxxxxxxx]

encapsulate your java programs in RPGLE procedures. That way, no-one has to
know the business end is Java. We have a consultant who is scared to death
of SQL. So when I write data access procedures for him to use, I just give
him the procedure name and he has no idea that it is SQL. The downside to
that is if it is not documented somewhere, the next guy will probably wish
that you get Herpes because he can't find out what is actually doing the
work.


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040
/"\
\ /
 X
/ \



                                                                                
                                                                      
                    meovino@estes-express                                       
                                                                      
                    .com                         To:     
midrange-l@midrange.com                                                         
             
                    Sent by:                     cc:                            
                                                                      
                    midrange-l-bounces@mi        Subject:     Output from PF to 
Excel XLS file in IFS                                                 
                    drange.com                                                  
                                                                      
                                                                                
                                                                      
                                                                                
                                                                      
                    02/07/2003 09:57 AM                                         
                                                                      
                    Please respond to                                           
                                                                      
                    Midrange Systems                                            
                                                                      
                    Technical Discussion                                        
                                                                      
                                                                                
                                                                      
                                                                                
                                                                      




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.


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