Re: Output from PF to Excel XLS file in IFS

[pnelson@xxxxxxxxxx]

   Mike,

   Bite the bullet and go with SEQUEL. I'm just finishing up 4 = weeks at a
   client where I've created several dozen routines over the JDE sy= stem
   that do exactly what you are looking for. The bulk of these run at nig= ht
   and produce all kinds of reports/spreadsheets that are emailed to the va   
rious recipients. The email addresses are stored in the JDE files for
   indiv= iduals, but to make things more efficient, I've used the
   distribution list = feature built in to the SEQUEL product.



   The client told = me last night that more stuff got accomplished in 4
   weeks than got done in = the last 6 months. Total RPG programs written: 2.
   Everything else is SEQUEL= objects with the run time variables wrapped
   inside CL programs.

   <FO= NT SIZE=2>meovino@estes-express.com
   Sent = by: midrange-l-bounces@midrange.com
   02/07/2003 09:= 57 AM
   Please respond to Midrange Systems Technical= Discussion

   To: midrang= e-l@midrange.com
   cc:
   b= cc:
   Subject: Output from P= F to Excel XLS file in IFS

   Does anyone know of any packages out there that will allow you t= o create
   XLS files from PF's?  CSV won't work here, the user absolu= tely,
   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 inte= rvention, so the
   package
   would need a command interface.
   <= FONT FACE="Monospace,Courier">I know about SEQUEL, but my boss thinks
   it'= s too pricey.  I'm working on
   learning Java, so I once I feel comfo= rtable with it, I suppose I could
   use
   HSSF, but I'm going to scare peopl= e 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, u= nsubscribe, or change list options,
   visit: http://lists.midrange.com/mailman/listin= fo/midrange-l
   or email: MIDRANGE-L-request@midrange.com
   Before po= sting, please take a moment to review the archives
   at http://archive.midrange.com/midrange-l.<= /FONT>