Excel and C/C++

[cfman]

Hi all,

For an Excel front-end GUI user interface, what's the best way to interface
it with a back-end computational engine using C/C++?

I guess there are numerous ways that can handle this -- I am looking for a
method that is not too complicated(I am not very experienced in Excel/VBA
programming), and most efficient ...

Thanks a lot

 

[Chip Pearson]

There are a variety of techniques you could use, depending on specifically
what you want to accomplish and what version(s) of Excel you need to
support.

XLL
This will work in any version of Excel, but you are limited to writing
functions that return a value or using the XL4 Macro language features. XLLs
don't support much in object model of current versions of Excel. However, an
XLL has very fast performance, the fastest of any method. There are a number
of template frameworks available on the net that do much of the housekeeping
task for you.

COM Add-In
This will work in Excel 2000 and later and provides full object model
support.

Automation Add-In
This will work in Excel 2002 and later. You can call functions in an
Automation Add-In directly from worksheet cells.

Visual Studio Tools For Office
This will work in Excel 2003 and 2007. This gives you full access to the
Excel object model plus the entire NET framework.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[cfman]

There are a variety of techniques you could use, depending on specifically
what you want to accomplish and what version(s) of Excel you need to
support.

XLL
This will work in any version of Excel, but you are limited to writing
functions that return a value or using the XL4 Macro language features.
XLLs don't support much in object model of current versions of Excel.
However, an XLL has very fast performance, the fastest of any method.
There are a number of template frameworks available on the net that do
much of the housekeeping task for you.

COM Add-In
This will work in Excel 2000 and later and provides full object model
support.

Automation Add-In
This will work in Excel 2002 and later. You can call functions in an
Automation Add-In directly from worksheet cells.

Visual Studio Tools For Office
This will work in Excel 2003 and 2007. This gives you full access to the
Excel object model plus the entire NET framework.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

Great! Thanks a lot for your help!

Which approach is the easiest considering my lack of experiences in
Excel/VBA coding?

My goal is to specify a bunch of parameters in Excel, and hit a button in
Excel to send the parameters to the back-end C++ computational engine, and
then send results back to Excel, and then hopefully Excel will generate a
plot, let's say a 2D plot, etc.

I know how to design a button in Excel, but that's linked to a macro in VBA;
I don't know how to link that button to C++, and how to let the Excel
program wait for the results and display a plot afterwards...

Could you please elaborate?

Thanks a lot and have a great weekend!

 

[cfman]

There are a variety of techniques you could use, depending on specifically
what you want to accomplish and what version(s) of Excel you need to
support.

XLL
This will work in any version of Excel, but you are limited to writing
functions that return a value or using the XL4 Macro language features.
XLLs don't support much in object model of current versions of Excel.
However, an XLL has very fast performance, the fastest of any method.
There are a number of template frameworks available on the net that do
much of the housekeeping task for you.

COM Add-In
This will work in Excel 2000 and later and provides full object model
support.

Automation Add-In
This will work in Excel 2002 and later. You can call functions in an
Automation Add-In directly from worksheet cells.

Visual Studio Tools For Office
This will work in Excel 2003 and 2007. This gives you full access to the
Excel object model plus the entire NET framework.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

Hi Chip,

Thanks a lot for your help!

I was also wondering if the following scheme is possible:

Users set parameters in Excel, and then hit a button to launch my C/C++
program, which does all the computations, and then waits for the C/C++
program to send back the results; once the results are available, the Excel
program will plot the results.

My question is: how does the Excel program knows if the results have been
sent back by the C/C++ program and are available?

More specifically, I guess when the users hit a button, it's going to be a
VBA macro, then how does VBA macro handles the above interface back and
forth with C/C++ back-end?

Thanks a lot

 

[Scott McPhillips [MVP]]

Hi Chip,

Thanks a lot for your help!

I was also wondering if the following scheme is possible:

Users set parameters in Excel, and then hit a button to launch my C/C++
program, which does all the computations, and then waits for the C/C++
program to send back the results; once the results are available, the Excel
program will plot the results.

My question is: how does the Excel program knows if the results have been
sent back by the C/C++ program and are available?

More specifically, I guess when the users hit a button, it's going to be a
VBA macro, then how does VBA macro handles the above interface back and
forth with C/C++ back-end?

Thanks a lot

There's an entire book about developing financial XLLs in C++. See this
article and the book references at the end.
http://msdn2.microsoft.com/en-us/library/aa730920.aspx