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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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.
 
Back
Top