Creating add-in for Excel using C#

c# excel add-in
Sambhaji picture Sambhaji · Jan 7, 2010 · Viewed 54k times · Source

I want to use C# class methods in Excel. Can anybody guid me how to do it ? The C# component will be excel add-in. How to create setup for this addin, so that I just need to give setup to user which will install add-in at client's machine. User should not need to do any other steps like registering the C# dll.

Answer

Govert picture Govert · Sep 25, 2010

(Disclaimer: I develop the Excel-Dna library.)

You should have a look at Excel-Dna - http://excel-dna.net. The library allows managed assemblies written in C#, VB.NET or F# to expose high-performance user-defined functions (UDFs) and macros to Excel through the native .xll interface. The project is open-source and freely allows commercial use.

With Excel-Dna you can create a single .xll add-in file that the user can open as an add-in without any further installation or registration. Excel-Dna add-ins can expose RTD servers and customized Ribbons for Excel 2007 and Excel 2010 without additional registration, so you need no extra setup program.

Related questions

Exception from HRESULT: 0x800A03EC Error

I am getting "HRESULT: 0x800A03EC" error when running Excel add-in with following code: Excel.Range rng = ActiveSheet.Cells[x, y] as Excel.Range; string before = rng.Value2; string cleanV = System.Text.RegularExpressions.Regex.Replace(before, @"\s+", ""); rng.set_…

Read More
Find the last used row in Excel with C#

Possible Duplicate: How to get the range of occupied cells in excel sheet Im trying to find the last used row in an Excel worksheet. For doing this, I'm using this code: int lastUsedRow = currentWS.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell,…

Read More
How to debug binding in WPF

I have a VS2008, C# WPF, Excel AddIn; Under some case, My addin throws exception like A first chance exception of type 'System.InvalidOperationException' occurred in PresentationFramework.dll A first chance exception of type 'System.NullReferenceException' occurred in PresentationFramework.dll …

Read More