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

 

[AlexesDad]

VB.NET & C# UDFs for Excel without much effort

Hi Ethan

At XLW we're about to release (free open source ) software that lets you write C++, C# & VB.NET user-defined functions ( packaged as .xll addins ) for excel.
The software is currently in Alpha but is very useable.

We put great effort into reducing the time taken by user to go from installing the software to creating a C# function and using it in Excel. In fact after installing the software, you just go to the Start menu and 'Extract a template' which produces the solution , project files and a .cs file ready to go. Just add a simple function into the .cs file and compile. Thats it. You will have built a .xll

Let us have your feedback if you decide to try it out.

Enjoy

A's Dad