How can I make a Excel template using my C# functions

[Guest]

Hi all,

I have some statictcle functions in C#, I am making some
Excel templates, they are xls files. How to make my
template using these functions?

Before these functions are in Excel VB so I used them in
my Excel template like this:
=FileName!FunctionName()

Lily

 

[Bret Mulvey]

Hi all,

I have some statictcle functions in C#, I am making some
Excel templates, they are xls files. How to make my
template using these functions?

Before these functions are in Excel VB so I used them in
my Excel template like this:
=FileName!FunctionName()

Lily

Excel has the CALL worksheet function which can be used to call a function
in an external DLL. While there are many legitimate uses of this feature
(such as you describe), it does present a security risk and so a security
patch was released that disables the CALL function. You'd only be able to
use this function on an un-patched system.

I'm not that familiar with Excel extensibility, so maybe somebody else knows
of another way to do this.