Developing User Defined Functions in Excel using C#?

Question

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

user1641568 · Accepted Answer · 2013-02-10 08:38:21Z

2

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

answered Feb 10, 2013 at 8:38

user1641568

Sign up to request clarification or add additional context in comments.

1 Comment

Govert Over a year ago

With Excel-DNA you need no installation or registration to make your worksheet UDFs work.

Sergey Vlasov · Accepted Answer · 2017-05-23 08:23:52Z

0

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

answered May 23, 2017 at 8:23

Sergey Vlasov

28.2k3 gold badges73 silver badges71 bronze badges

Collectives™ on Stack Overflow

Developing User Defined Functions in Excel using C#?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related