My colleague Terry Aney has posted a detailed article on the “fun” he’s had creating Excel add-ins in C# (after migrating from XLAs + VBA). If you need to make several thousand calls between add-ins and Excel and want to use .NET, you should definitely run some performance comparisons first 🙂
In a related post he discusses source control strategies / workarounds for XLA files.
[…] Excel Add-Ins in C# (Chris Cavanagh) […]
some excel help
http://csharp.net-informations.com/excel/csharp-excel-tutorial.htm
Hi
Something of interest for you, its now possible to, very easily, write C# xlls for excel using xlw v4
https://sourceforge.net/project/showfiles.php?group_id=45222&package_id=37893&release_id=683127
…. sorry that link should have been
http://sourceforge.net/project/showfiles.php?group_id=45222&package_id=37893&release_id=690866
i.e http not https
Some examples
http://book.greenwich2greenwich.com/Examples/
[…] Found via: https://chriscavanagh.wordpress.com/2008/04/13/excel-add-ins-in-c/ […]
Hi, Is it possible to create controls dynamically in the excel 2010 ribbon thru an addin? Iam using C# and VS 2010.
More info about excel formulas
I’m looking at building an add-in for Excel.. a substantially large application-y one. What are the performance comparisons you’re referring to? Can you give me some more info? I’m trying to decide between C# and VB .net, as it seems Microsoft Sharepoint supports both? (at least it gives code samples for both..?)