Basic of XLL Excel Addin - Need to invoke a C# API

Question

I am quite new to creating excel addins.

Earlier I used to create a tlb for .NET libraries. I used to make my .NET class COMVISIBLE and create a Com callable wrapper and register as a tlb to call from Excel (using regasm).

I now have a math library written in C#. Got to know there is something called XLL and UDFs which I can use to invoke API's from the DLL. Little confused about XLA, XLL and UDFs. Not sure what should I do to call my API's.

Not sure where to get started. Any help would be helpful.

Thanks Mani

Answer 1

Take a look at XLDNA, XLL+, Addin Express, VSTO etc.

Answer 2

Don't forget to take a look at http://nxll.codeplex.com too.