Search code examples
c#excelvstoadd-in

Developing User Defined Functions in Excel using C#?

I am developing a User defined function in Excel using C# and Class library in VS 2010. I followed the tutorial at How to Create UDF in Excel using C# The code works well and it gets Registered.I can see my AddIn in InstalledAddIN list. However after clicking on the Insert Function button in the formula bar. From the dialog of available formulas, “Or select a category” drop down box I cannot see my Function that I have built I am using VS 2010(Admin mode) however excel is in guest mode.Does privileges has to do anything with it.??

Could Also anyone explain me how can i install my AddIn? Thank you for your time

Solution

  • Take a look at Excel Dna.It is an open source project used to integrate Excel with .NET also check Excel 2013 XLL