Introduction to the Excel Services JavaScript OM – Part 2 – listening to events

The previous post showed how to start using the Excel Services JavaScript OM to automate the EWA web-part. The example given showed how to cause periodic recalculation on a workbook that’s on a SharePoint web-page. In this post, we will add our first event to the EWA and see how we can get an even…

1

Introduction to the Excel Services JavaScript OM – Part 1 – Humble beginnings

Edit: I fixed a problem with the skeleton code that made the thing not work in browsers other than IE.  In the past few weeks, I wrote a bunch of posts about the new REST APIs in Excel Services. I wanted to take a bit of a breather from those APIs and start writing about…

2

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…

8

Excel Services REST APIs – the basics

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 of the REST APIs – essentially a list of all the entities that…

1

Reason #4871 why I hate DHTML

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.


Getting ranges via Excel Services REST as well as Charts and Discovery

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 of data – specifically ranges from the spreadsheet. Now, Excel Services…

3

Discovery via the Excel Services REST APIs

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 users to explore the content of the workbook either manually or programmatically…