This is concerning the use of Excel as the front-end for a program written in C++. The input and output is done in Excel, but the processing is done in C++.
Say that we have to multiply 'a' and 'b', available in cells A1 and B1 of Excel, and we want the product to be displayed in cell C1 of Excel too, but the product has to be calculated with a C++ program. How do I do it?
Do I have to work
1) exclusively in Excel,
2) exclusively in C++ or
3) part in C++ and part in Excel?
Do I need to store the intermediate results in a file or, otherwise, how do I get the cells I need (A1 and B1 in the example above) from C++?
Any guidance in this area will be very much appreciated.
I'd like to know where to start.
Say that we have to multiply 'a' and 'b', available in cells A1 and B1 of Excel, and we want the product to be displayed in cell C1 of Excel too, but the product has to be calculated with a C++ program. How do I do it?
Do I have to work
1) exclusively in Excel,
2) exclusively in C++ or
3) part in C++ and part in Excel?
Do I need to store the intermediate results in a file or, otherwise, how do I get the cells I need (A1 and B1 in the example above) from C++?
Any guidance in this area will be very much appreciated.
I'd like to know where to start.
