Managed Code UDF without Excel Services?

[Ethan Strauss]

Hi,
I would like to be able to write User Defined Functions for Excel 2007
using C#.net in Visual Studio 2008 with using Excel Services. I have found
lots of stuff (e.g. http://msdn.microsoft.com/en-us/library/ms493934.aspx)
for UDFs using Excel services, but I just want to make an add-in with
functions and have those functions available for people who have that add in
even without people connected to a Server. Is that possible? How should I do
it?
Thanks!
Ethan

 

[Chip Pearson]

I have step-by-step functions for creating class libraries in NET
whose functions can be called directly from worksheet cells. The
examples are in VB.NET but you can probably translate them to C# with
little effort.

See http://www.cpearson.com/Excel/CreatingNETFunctionLib.aspx for
complete details.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Ethan Strauss]

Thanks!
That looks good. I may have more questions as I start working through it.

Ethan