First "Hello World" code sample with the Excel Services APIs!

Welcome to the new world of Excel Services in the Microsoft Office Sharepoint Server 2007 product line! During the next few months, I will be exploring the various programmability capabilities of Excel Services.   On this first post of many, we will make our first “Hello World” application that uses Excel Services to execute Excel…


Image Resizer for Vista (and XP) – Just a right click away from Explorer.

You can download the resizer here. I don’t know about you, but I am sorely missing the XP toy for image resizing. Windows XP had its power-toys, but Vista does not. And while some functionality has been baked into the shell, explorer right-click has not. On top of that, a feature I have been wanting for a…


Image Resizer Download Page

Image Resizer has moved. You can find the downloads here.


That annoying c:windowsassembly folder

If you are anything like me, you want to tear your hair out and smash your head on a concrete wall with embedded rusty nails everytime you need to use Explorer (and any file-open dialog box) on the c:\windows\assembly directory. While I am still working with my therapist on these issues, I decided to be…


Another tool for working around Excel Services not supporting QueryTable

Abdullah Kavi (with some help from Bob Archer) from the Excel Test Team has taken Boaz’s solution for converting query tables so that their data can be consumed in Excel Services and added quite a few features to it. In his own words: —- I have created an Add-In based on Boaz’s original add-in and…


Excel Services UDF, be not synchronous

In a previous post, I show you how to create a UDF that resolves internet names by using a DNS lookup web service. In this post, we will discuss how we can make potential uses of this UDF even faster.   Continuing the example of the DNS look up, what if we wanted to look…


How to add support for External Workbook References to Excel Services

In v1, Excel Services will not support External Workbook References. This is due to various reasons, not the least of which is that the model itself does not lend itself in exactly the same manner on the server as it does on the client side. That said, I will show you a relatively simple UDF…


Making Excel Services UDFs work on Excel 2007 – Part 1

I have made a few posts about UDFs over the past couple of months. One of the things I neglected to explain is how to make server targeted UDFs work on the client. Among other reasons why one would want that, is the fact that it’s useful to actually see what the results of your…


Excel Services Compatibility Checker Download Page

Version 0.1.914.0 Add ability to fix external references + allow finer control over what checks are done. See the post for more information. Version 0.1.904.0 Fix the issue of External References not being located. See the post for more information. Version 0.1.816.0 Now checking for protected chart-sheets as well. See the post for more information. Version 0.1.731.0 Added another check…


How UDFs work in Excel Services – a Primer

In the past few posts, I described the various ways to communicate with Excel Services from without – when you want to do operations such as calculate a workbook, get back values etc. In this post, I will introduce you to how to extend Excel Services from within by adding User Defined Functions (UDFs) that…