Restplorer – visual exploration tool for Excel Services 2010 REST capabilities

At the beginning of the year, I wrote a little web app that lets you get embed code for REST URLs/elements in Excel Services in a very easy way – instead of crafting the URL yourself, or navigating through ATOM feeds, you get a nice UI to do that. Well.. Not really “nice” as much…


You can access arbitrary ranges via REST – here’s the trick

Reader JJDE asked in this post if it was possible to access arbitrary ranges with REST – you just need to use a pipe character where you would usually place a colon: http://tsdlt2/_vti_bin/ExcelRest.aspx/Docs/Bugs.xlsx/Model/Ranges(‘Sheet1!A1|Z100’) This will return the Sheet1!A1:Z100 range. As for why we had to do this.. IIS does not like colons in the path…


Excel Services REST limitations

We just went through two or three weeks worth of posts and I tried to show you some of the new stuff we can do with Excel Services. It’s cool, it’s exciting, it’s great. But here comes the caveat post!! There are a number of things that do not currently work in REST – the…


Coding the Excel Services Windows 7 Gadget – Part 4 – Fly-outs

One of the features gadgets posses is the ability to have a “fly-out” visual aid for “zooming in” or “drilling down” on parts of the gadget. The Excel Services gadget supports that too – for certain types of links. Generally speaking, one should not muck around with the HTML that comes back from Excel Services….


Coding the Excel Services Windows 7 Gadget – Part 3 – Ranges

The first post in this series talked about how to code the settings window and the second talked about how the chart contents is displayed on the gadget itself. In this post, I will show how ranges are treated when the user requests to see them on the gadget. Ranges (and tables and PivotTables) are…


Coding the Excel Services Windows 7 Gadget – Part 2 – Charts

The first part of this series showed how the code in the Settings form worked in the gadget. In this part, I will start describing how the gadget fetches the requested information from Excel Services and displays it. As a reminder, here’s what the gadget looks like when minimized and showing a chart: The gadget…


Coding the Excel Services Windows 7 Gadget – Part 1 – Settings

In the next few days, my posts will revolve around the mechanisms that make the Excel Services gadget tick. I won’t talk a whole lot about Gadget development – that could easily take up 4 or 5 posts – I will give a very brief overview though on what a gadget is and how it…


How to seamlessly embed data from Excel Services spreadsheets into Word

One of the fun things about working on the programmability aspects of Excel Services is realizing just how many interesting scenarios exist that you never thought of originally. I got an IM from Dany Hoter asking for help on an issue he ran into with one of his customers. I have been working with Dany…


Advanced Excel Services REST API capabilities – passing parameters to a spreadsheet

So far in the posts discussing Excel Services REST, I showed how easy it was to gain direct access to elements within workbooks. One immediately sees the potential of really releasing the data and the visualization that’s locked within Excel and making it easily available on the web. The really advanced stuff though is a…