Rohit
Rohit

Reputation: 10236

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

Upvotes: 0

Views: 2262

Answers (2)

Sergey Vlasov
Sergey Vlasov

Reputation: 27880

You can write Excel User Defined Functions using C# directly with my ESharper add-in without additional files and registration.

Upvotes: 0

user1641568
user1641568

Reputation:

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

Upvotes: 2

Related Questions