Making Excel Services UDFs work on Excel 2007 - Part 2

Microsoft Excel 2007 (nee Excel 12) : Making Excel Services UDFs Work in Excel 2007

Fri, 01 Sep 2006 20:34:54 GMT

PingBack from http://blogs.msdn.com/excel/archive/2006/09/01/735561.aspx

Pre-requisites

LuisBE on Services — Fri, 29 Sep 2006 08:48:23 GMT

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

re: Making Excel Services UDFs work on Excel 2007 - Part 2

TS — Tue, 06 Feb 2007 03:17:45 GMT

I have mentioned this before, but I was thinking that with Office 2007, the need to mess with COM altogether should be a thing of the past. Why aren't there ways of doing everything without COM? Is that a plan to remove all dependence on COM (i personally don't like getting my hands dirty messing with it).

thanks !

re: Making Excel Services UDFs work on Excel 2007 - Part 2

Shahar — Tue, 06 Feb 2007 04:08:52 GMT

I cannot comment about future developments in Office of course.

However, this I do know:

1. Though I don't know for sure, I personally doubt we will "get rid of COM" anytime soon - there are too many solutions that rely on it and that would break all of them.

2. With every version, I think we make some nice progress with the managed story we have. Hopefuly at some point in the future (and I really cant say when, because I honestly dont know) there will be less and less need for COM when programming against Excel.

Erweiterungsbibliothek für Excel-Tabellenfunktionen in Managed Code schreiben

Open XML, VSTO, Deployment, .NET und anderes — Wed, 09 Apr 2008 15:58:30 GMT

Hin und wieder werde ich gefragt, ob man mit VSTO auch Tabellenfunktionen für Excel schreiben kann. Nun,

re: Making Excel Services UDFs work on Excel 2007 - Part 2

Johnson — Tue, 19 Aug 2008 19:04:56 GMT

Hi,

How the following code snippet can make work for excel 2007 client - Here Object array as output - I'd really appreciate if you can explain how to do it.

[UdfMethod(IsVolatile = true, ReturnsPersonalInformation = true)]

public object[,] getSharepointView(string serverName,

string siteName,

string listName,

string viewName,

bool getTitles)

Thanks,

re: Making Excel Services UDFs work on Excel 2007 - Part 2

Shahar — Tue, 19 Aug 2008 19:13:40 GMT

Hi Johnson,

This should pretty much work the same way on client - what error are you seeing?

re: Making Excel Services UDFs work on Excel 2007 - Part 2

Johnson — Tue, 19 Aug 2008 19:34:38 GMT

I'm seeing #VALUE- but the following one is working fine

[UdfMethod(IsVolatile = true, ReturnsPersonalInformation = true)]

public object externalRef(string workbookPath,

string sheetName,

string range)

{

So i'm suspecting that an object array output giving error.

re: Making Excel Services UDFs work on Excel 2007 - Part 2

Youdhbir Singh — Sat, 20 Sep 2008 11:52:21 GMT

//You make following changes in the code (class1.cs) provided and pass your site base address in site name

// For me sitename="http://hddlntdmt0281:100". And press ctrl+shift+enter to run your UDF (as it is

// returning array. Please let me know if u still get problem. :-)

public object[,] getSharepointView(string siteName, string listName, string viewName, bool getTitles)

{

try

{

// We should impersonate the current user viewing EWR... not the UDF manager...

//using (WindowsImpersonationContext wiContext = impersonateUser())

//{

// Grab Sharepoint Objects

SPSite site = new SPSite(siteName);

SPList list = site.AllWebs[""].Lists[listName];

SPView view = list.Views[viewName];

re: Making Excel Services UDFs work on Excel 2007 - Part 2

Andrew — Thu, 08 Jan 2009 23:55:12 GMT

How do you stop the Excel web access returning #VALUE! when using the above code in a UDF?

re: Making Excel Services UDFs work on Excel 2007 - Part 2

Andrew — Thu, 08 Jan 2009 23:55:20 GMT

How do you stop the Excel web access returning #VALUE! when using the above code in a UDF?