How to Deploy Excel addIn project with user defined function developed in c# with setup wizard?

Question

I have developed an Excel add-in application with a User Defined Function (UDF) in c#. I have created an installer .vsto file using the setup wizard. It's working fine and my ribbon gets loaded in Excel.

The problem is that when I try to insert a UDF function in my worksheet, the function is not visible in my function wizard or does not load.

Why is this happening and what can I do to solve this?

Answer 1

VSTO IS NOT DESIGNED TO SUPPORT UDFs, if you really need to have UDFs for Excel written in C# (or .NET generally), you have some solutions to choose from, includes, but not limited to:

• Automation (COM) Add-ins: here is a good article about this.
• Excel DNA: a free and open source project, available at: http://excel-dna.net/
• Addin Express: Which is a commercial product: http://www.add-in-express.com/docs/net-excel-udf-tips.php

Finally, a good Code Project article to read about UDFs.