So what does REST on Excel Services look like???

In my first post about Excel Services and REST, I showed how to construct a simple REST URL pointing directly to a PNG in a workbook. This post was supposed to be about the discovery built into the Excel Services REST API. However, I got a couple of questions about what my previous post actually…

6

Welcome to the new Excel Services!

Now that Microsoft SharePoint Conference 2009 is done, I have some more time to start posting about all the nice things we have done with SharePoint 2010 – especially with Excel Services. In the coming months, I will post about Excel Services, concentrating on some of the new capabilities we enabled via our new extensibility…


Who’s Afraid of the big-bad cast operator?

My previous blog entry (which was completely misunderstood by some people who commented – I blame the fact that English is not my native tongue) reminded me of another poor coding behavior. Just so we don’t have a repeat of that last post, let me clarify that I have nothing against the as operator -…

5

Using a Generic return type that does not appear in the parameter list – when to use it

EDIT: Contrary to what people understood from this post, it is NOT a “Do not use Generics” post – I think Generics are a GREAT addition to the language/framework and I use them all the time. It is against a very specific usage of Generics  Short Answer: Rarely. Slightly longer answer: When you are aware…

5

COM Library for Excel Web Services – Use EWS from VBA!

In the ODC 2008, I gave a demo of how to use Excel Web Services from a VBA client – the demo was basically just a managed library that wrapped a generated Web Services proxy. Since Microsoft no longer seems to supply a SOAP toolkit for office, this is the easiest way of achieving access…

3

Single-select Dimension member Analysis Services Filter Web Part

A long long time ago, in a building far far away, two Jedis developers called Sreepada Santhegudda and Sergei Gundorov showed me a solution they came up with for a single-select Analysis Services filter web part. While SharePoint ships with a set of filters that allow users to build interesting dashboards, and while one of…

3

Using C# 3.0 Extension Methods to make life easier when using optional parameters in Office PIAs

Gabhan Berry (read his blog – he has lots of Excel programmability related information in there!) wrote a piece about how to make using optional parameters a little less painful when using C# to program against the Excel (and any other) COM PIA object model. While his solution makes life much easier in some scenarios,…

1

EWA Companion Part 4: Refresh/Recalc functionality

In the first part of this post series I showed the EWA companion and its various capabilities. In this part, I will delve deeper into the “Automatic Refresh/Recalc” capabilities of the companion. This feature is divided into two parts – refresh and recalc. Refresh is mostly only useful when your workbook contains a Pivot-Table that’s…

4

Code Art – like ASCII art, only sucks so much more to create….

I have made two examples of Code Art – taking a piece of code that does something and placing the text in such a manner that it conveys the idea of the program. The reason it sucks so much more than ASCII art is two-fold: a. It is very hard to do significant touch-ups to…

8

EWA Companion Part 3: Open/Download functionality

In the first part of this post series I showed the EWA companion and its various capabilities. In this part, I will delve deeper into the “Open” functionality of the EWA Companion web-part. There are a few reasons behind adding the Open command to the EWA. While the functionality already seemingly exists in it (You…

16