Re: Output from PF to Excel XLS file in IFS

Which is what I'll do if we go that route.  But still there is "the fear."

Mike E.



                                                                                
                                          
                    MWalter@hanoverwire.c                                       
                                          
                    om                          To:     Midrange Systems 
Technical Discussion <midrange-l@midrange.com>   
                    Sent by:                    cc:                             
                                          
                    midrange-l-bounces@mi       Subject:     Re: Output from PF 
to Excel XLS file in IFS                  
                    drange.com                                                  
                                          
                                                                                
                                          
                                                                                
                                          
                    02/07/03 10:25 AM                                           
                                          
                    Please respond to                                           
                                          
                    Midrange Systems                                            
                                          
                    Technical Discussion                                        
                                          
                                                                                
                                          
                                                                                
                                          





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.





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