How UDFs work in Excel Services - a Primer

re: How UDFs work in Excel Services - a Primer

Rob — Tue, 04 Apr 2006 21:11:34 GMT

>Creating UDFs for Excel Services is incredibly simple. All you need is something that can create .NET 2.0
>assemblies and about 5 lines of code. Using UDFs, you can augment the existing Excel Services formulas
> and add your own.
This is sweet, but why isn't it included on the client version of Excel? Automation add-in are a pain and slow, and calling .NET code from an XLL is not the easiest thing.

UDF Rules and guidelines

Cum Grano Salis — Fri, 07 Apr 2006 04:49:28 GMT

A description of what's supported (type wise) in Excel UDFs.

re: How UDFs work in Excel Services - a Primer

Govert van Drimmelen — Fri, 07 Apr 2006 13:53:17 GMT

There are some 3rd party options for creating managed UDFs for the Excel client. The free ExcelDna library is an option (http://exceldna.typepad.com) as is the commercial ManagedXLL project.
For ExcelDna I will consider building compatibility with the Excel Services UDF story - it looks quite easy from what I see so far. If I get it right, this will allow you to use the same assemblies in the Excel client and in Excel Services.

Excel Services UDF, be not synchronous

Cum Grano Salis — Wed, 12 Apr 2006 03:24:31 GMT

Excel Services UDFs can use any dirty trick in the .NET book (as long as not blocked by the admin). In this post, we will show how a UDF can greatly increase performance of multiple calls made to web-services.

How to add support for External Workbook References to Excel Services

Cum Grano Salis — Tue, 02 May 2006 21:18:40 GMT

Excel Services does not support External Workbook References. I show how you can use a UDF to get similar functionality.

Making Excel Services UDFs work on Excel 2007 - Part 1

Cum Grano Salis — Fri, 04 Aug 2006 00:26:40 GMT

I have made a few posts about UDFs over the past couple of months. One of the things I neglected to explain...

Making Excel Services UDFs Work in Excel 2007

Microsoft Excel 2007 (nee Excel 12) — Fri, 01 Sep 2006 20:33:08 GMT

Shahar Prish, one of the developers on the Excel Services team, has recently posted a few entries on...

Call Java from Excel Services? Yes you can!

All About Interop — Thu, 28 Sep 2006 22:24:39 GMT

This is an example ofwhat is possible when web services is baked into the platform.&nbsp; Excel Services...

Sharepoint 2007 UDF primer

Digging .NET — Thu, 28 Sep 2006 23:34:51 GMT

Sharepoint 2007 UDF User Defined Functions

Pre-requisites

LuisBE on Services — Fri, 29 Sep 2006 08:45:32 GMT

Instead of re-hashing information I've found elsewhere I figured a pre-reqs post would be good.
One...

Pre-requisites

LuisBE on Services — Tue, 31 Oct 2006 03:50:24 GMT

Instead of re-hashing information I've found elsewhere I figured a pre-reqs post would be good. One of

Excel Services and User Defined Functions in Managed Code

edhild's WebLog — Sat, 30 Dec 2006 06:17:39 GMT

So I just finished coding the solution for my chapter on Excel Services. The more I dig deep in this

Call Java from Excel Services? Yes you can!

All About Interop — Fri, 10 Aug 2007 03:37:20 GMT

This is an example ofwhat is possible when web services is baked into the platform. Excel Services in

Christian Stich on Excel Services: Financial option valuation implemented with Monte Carlo simulation using multithreaded User Defined Functions (UDFs)

Microsoft Excel — Wed, 15 Aug 2007 06:25:46 GMT

Today’s author: Christian Stich, a program manager on the Excel Services team who likes to combine his

Christian Stich on Excel Services: Financial option valuation implemented with Monte Carlo simulation using multithreaded User Defined Functions (UDFs)

Noticias externas — Wed, 15 Aug 2007 06:37:35 GMT

Today’s author: Christian Stich, a program manager on the Excel Services team who likes to combine his

re: How UDFs work in Excel Services - a Primer

Rathna Subbu — Fri, 09 May 2008 22:59:31 GMT

I am trying to call a MOSS web service from Excel UDF with the calling users security context with Trusted Subsystem and i am getting the following error. Can anyone point the correct way without using Delegation mode?

Unable to cast object of type 'Microsoft.Office.Excel.Server.CalculationServer.WorkOnBehalfIdentity' to type 'System.Security.Principal.WindowsIdentity'.

thanks

Rathna