Excel DNA Learning Note (ii) simple UDF custom function

How do I add a custom function to Excel by using Excel DNA?

1. Create a new class file on the Class Library project, let's call him MyUdf.cs.

2. Add a static method to this class, as follows: NOTE: it must be a static method.

     Public classmyudf {[Excelfunction (Name="Say", Description ="My first. NET function", Category ="This is a category grouping")]         Public Static stringSayHello ([excelargument (Name ="name", Description ="Incoming name")]stringname) {            return "Hello World"+name; }    }

3. Feature Explanation:

4. In Excel cell input =say (), you will find surprise

Excel DNA Learning Note (ii) simple UDF custom function