Cum Grano Salis

There are a few things I want to change/fix and a few features I want to add to the gadget. Here they are, in no particular order: Changes: 1. I want to change the way the gadget works to be more like the fly-out – instead of relying on the settings to...

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...

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...

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...

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...

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...

In the past two weeks I detailed both the new REST functionality in Excel Services as well as the Excel Services Gadget (which will hopefully be available for download soon). In the previous post I showed how you can use URL parameters to REST URLs to...

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...

The last post I wrote, I showed the Excel Services gadget and how it can be a great tool for bringing your Excel data right to the desktop. In this short post, I will show some of the other capabilities it has – namely, the ability to show ranges on top...

The past few posts have shown some of the basic REST functionality you can expect to get from the new Excel Services that will ship as part of SharePoint 2010. Before going into some of the more advanced features (well.. feature) of Excel Services REST...

Last week I posted a number of pieces about the various ways the new Excel Services REST APIs allows developers to leverage data and elements from within workbooks by giving direct URLs to them. This post contains details about the available capabilities...

Just thought I’d drop a quick note as to what to expect to see this week.. Today there will be a post about the basics of REST – essentially a reference manual to all the basic capabilities of the API. After that, there will be two posts about the Excel...

Margins. In script. To set? Use element.style. marginTop . To get in runtime? Use element. topMargin . Arghhhhhhh! It's like DHTML is forcefuly trying to make me hate it.

The previous post (and the one before ) showed how the Excel Services REST API allows developers to discover information about a workbook as well as get back images of live charts from an Excel Workbook. It is also quite possible to get other types...

In my previous post , I showed what embedding a chart from Excel Services inside a blog looks like. In this post, we will take a step back and explore the discovery mechanisms built into the Excel Services REST APIs. Discovery allows developers and...

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...

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...

The folks in Office Operations released the Uls Viewer tool – it allows users of SharePoint to easily view and analyze ULS logs produced by the system (though not initially designed for user consumption, people seem to have been using the logs pretty...

I was going to get coffee today at work, minding my own business, when someone from the test-team asked me if the order I was doing things when preparing coffee was intentional. Absentmindedly, I explained the reasoning behind the order of things and...

I found out about this feature a bit ago and.. Wow.. I am so impressed. The set-up procedure is a little convoluted, but once you do it, the thing just works. Here’s the idea: Allow your identity (your Windows Live account, basically) to stream your media...

Image Resizer has moved to another blog – this way it does not interfere with this blog which is all about Excel Services – my actual daytime job. Find it here!

Now that the x64 issue and the non-latin characters issues are solved, what new features would you like to see in the resizer? Post your comments.

Well.. It’s been a while since I updated.. Short and sweet – this is the new version of Image Resizer. There are 2 setups now – one for 32bit and one for 64bit. This also solves the issues people have been having with foreign characters making resizing...

This article contains some basic troubleshooting/tips on using Excel Services.

Sergei Gundorov (whom you may remember from a previous post ) has published a paper on MSDN where he talks about a very interesting solution his team wrote in the Microsoft IT department. The solution is probably one of the most advanced implementation...