Hi,
For some time now I have been using an application built in Excel which
transfers
arrays of data to S+ for manipulation and calculations and fetches results
from S+ and displays them in Excel. It uses COM communication and is very
simple to program in VBA on the Excel client side and is trivial on the S+
side. The application was based on an example that is shipped with shipped
with S+ as an example of "Using S+ as an Automation server" in
samples/oleauto/vba/Excel/Book1.xls.
Due to an increase in the size of the array and slower performance under
S+7 I have been thinking about ways to try to increase the performance. The
arrays I pass have several thousand rows and between 30 and 40 columns and
it appears that most of the overhead is passing data to S+ and pulling it
back. The S+ functions themselves run fairly quickly.
I am investigating the possibility of having Excel call C++ and then C++
call S+. I have some experience with C++ but not much under the Windows
environment.
Has anyone any experience or comments about linking C++ to S+ or connecting
Excel to C++ even?
Thanks in advance,
Maeve
I am using S+6.2 under Windows NT.
|