Re: Newbie Questio- ish

Posted in 1998

John H. Frantz — Thu, 30 Jul 1998 11:46:02 +0100 — source: Informix-list mailing list archive (1991-1998)

A terminal emulator like Reflection from WRQ (see http://www.wrq.com) might work for you. It has a very powerful scripting language with OLE capabilities that works with Excel. I've used it to send reports from 4gl directly into Excel. ---------------------------------------------------------------------- John H. Frantz Power-4gl: Extending Informix-4gl john@rl.is http://www.rl.is/~john/pow4gl.html Nils Myklebust wrote: > > It's possible you could do this in Dynamic 4GL. I saw some examples of > controling Excel via DDE. Whether that's only write or read back as > well I have no idea. > > Another way is to get an advanced terminal emulator with a resonable > scripting language. Then you could send a command to the emulator (via > a simple display statement in 4GL) to execute a script that controlled > Excel. It could send data to Excel, read data back and give them as > input to the 4GL program (as if the user typed in the data). With the > Glink emulator we use this would not be all that hard to implement. > Check out http://www.gar.no or http://www.gr.co.uk for more > information. > > On Wed, 29 Jul 1998 19:15:53 +0100, Charles Millward > <chaz@blakspot.demon.co.uk> wrote: > > >Fellow 'Mixers > > > >Probably not an Informix question, but ... > > > >Using OnLine DS 7.2 on HP-UX 10.20 and 4gl that comes with 7.2. > >Currently we call "C" functions to work out actuarial calculations > >returning a 400 element array with the data we require for posting to > >various tables. > > > >We now want to access a Microsoft Excel spreadsheet on a PC with the > >actuarial formulas, bring back to 4gl on the Unix box and make the > >calculation with a mix of C and 4gl > > > >Anyone any idea how we connect to the PC, open the spreadsheet, return > >the correct calc and bring it back to unix. > > > >All positive suggestions greatly accepted > > > >Chaz > > > > Nils Myklebust > NM Data AS > Norway > E-mail: Nils.Myklebust@nmdata.com > FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html > (Now with ODBC info under "Third party products".)