Using C# .NET User Defined Functions (UDF) in Excel

Adam Tibi

Rate me:

5.00/5 (7 votes)

13 Jun 2013CPOL4 min read

68.9K

331

Exposing .NET functions to be consumed as Excel functions, otherwise known in Excel as "User Defined Functions" . Those .NET exposed functions can be easily used from Excel's cells. This article presents two ways to achieve this and the pros and cons of each.

excel-udf-c-sharp-sample.zip
- AutomationSample
  - AutomationSample.cs
  - AutomationSample.csproj
  - AutomationSample.xlsx
  - bin
    - Debug
      - AutomationSample.dll
      - AutomationSample.pdb
      - AutomationSample.tlb
      - ExcelUdf.Automation.dll
      - ExcelUdf.Automation.pdb
  - Properties
    - AssemblyInfo.cs
- ExcelUdf.Automation
  - bin
    - Debug
      - ExcelUdf.Automation.dll
      - ExcelUdf.Automation.pdb
  - ExcelUdf.Automation.csproj
  - Properties
    - AssemblyInfo.cs
  - UdfBase.cs
- ExcelUdf.ExtensibilityAutomation
  - bin
    - Debug
      - ExcelUdf.Automation.dll
      - ExcelUdf.Automation.pdb
      - ExcelUdf.ExtensibilityAutomation.dll
      - ExcelUdf.ExtensibilityAutomation.pdb
      - ExcelUdf.ExtensibilityAutomation.tlb
  - ExcelUdf.ExtensibilityAutomation.csproj
  - Properties
    - AssemblyInfo.cs
  - UdfExtensibilityBase.cs
- ExcelUdf.sln
- ExtensibilityAutomation
  - bin
    - Debug
  - Class1.cs
  - ExtensibilityAutomation.csproj
  - Properties
    - AssemblyInfo.cs
- ExtensibilitySample
  - bin
    - Debug
      - ExtensibilityAutomationSample.dll
      - ExtensibilityAutomationSample.pdb
      - ExtensibilityAutomationSample.tlb
  - ExtensibilitySample.cs
  - ExtensibilitySample.csproj
  - ExtensibilitySample.xlsx
  - Properties
    - AssemblyInfo.cs
- XllSample
  - bin
    - Debug
      - XllSample.dna
      - XllSample.xll
  - Properties
    - AssemblyInfo.cs
  - XllSample.cs
  - XllSample.csproj
  - XllSample.xlsx
excel-udf-c-sharp-sampl.zip

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Adam Tibi

Architect

United Kingdom

Passionate about refining software practices, promoting self-motivated teams and orchestrating agile projects.
Lives in London, UK and works as a .NET architect consultant in the City.

Blog AdamTibi.net.

Using C# .NET User Defined Functions (UDF) in Excel

License

Comments and Discussions