If you're open to commercial solutions, our RPG2SQL Integrator Excel functionality could allow you to access spreadsheet functions, make a call to selected calculations and return the date to the iSeries 5250 RPG application directly.
You would call our API just like any other subroutine or procedure.
Why re-write the Excel logic in RPG when you can use the existing spreadsheet from RPG ?
If you're interested in learning more, send me a copy of your spreadsheet with some instructions and we can demo the functionality for you.
Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
-----Original Message-----
----------------------------------------------------------------------
message: 1
date: Thu, 15 Mar 2012 22:19:03 +0100
from: Dave <dfx1@xxxxxxxxxxxxxx>
subject: Access Excel formulae from an RPG
Hi all,
Today I was presented with the most complex set of mathematical instructions in an rpg program I have ever seen. (insurance tariffs).
I was not involved in the development but as I was involved in other tests on the product, that used these calculations, I was asked to control the tariffs that were shown during the course of my own tests.
The user had supplied an Excel spreadsheet which we could use to enter any test amounts to get the different details of the tariffs. So, to test the rpg code, we are basically creating a client on a 5250 screen and checking the displayed tariffs calculated by the rpg program with those obtained with the spreadsheet. It doesn't seem right to me that we have basically 2 copies of the formulas needed for the calculations, the user's in the spreadsheet and ours in the rpg program. The rpg code used to reproduce the excel formulae is very complicated, and the programmer who wrote it is using the debugger to be able to see the result of the different steps in the calculation!
How could the rpg program access directly the user's formulae? I thought web service, but I would not really know where to start.
Thanks in advance for any suggestions.
midrange.com
