3
Reply

create a component for Excel

rod riggs

rod riggs

Feb 25 2011 8:16 AM
8.7k
Hi everybody,

I'm a c++ developer experimented on linux, thus I don't know well windows, neither C#. And I want to create a .net component, for windows, with C#, that will be made of:
1.a) a very simple HMI made up of only one button
1.b) a function F that take 2 parameters (of integer type), and do something (this function is already done). This function will be called when the button is clicked.

This component must:
2.a) Appear in the list of objets that can be inserted in Excel (in Excel: menu -> insert -> object)
2.b) Once inserted in an Excel sheet, we can link 2 cells to the parameters of the functions.

The final result will be:
we got a button in a Excel sheet, and when we click it, the function F is called with two parameters, wich parameters are the content of 2 cells of the sheet.

I have tried some things, but without success: i'm blocked in the 2.b, i mean that i didn't manage to make that my component appears in the Excel's insertable object list.

Can anyone could explane me a bit the arcanes of the .net components and their insertion in Excel?
Do anywone know where can I find some informations, source code, examples, about this subject?

Thanks a lot.
Rod.

Answers (3)