So what else can OpenXML + ASPX + Excel Services can do?

In my previous post, I stole code that showed how developers can write code that will generate XLSX files by using the fancy OpenXML SDK on the fly. At the end though, I explained how a workflow activity would have been much better for the scenario I presented, at least from a performance point of…

2

“Something interesting” Sample app – Coding – Part 1 – Building the page

This post shows how to code the sample application shown on this blog. In my previous post, I showed the “I found something interesting” app which allows users to analyze workbooks and publish their insights. With the following few posts, I will show how this solution is coded. The first element of the solution is…

0

Sample application “I found something interesting”

Another week, another app (and I use “app” loosely – it’s a SharePoint web-part page). The following sample application is used to allow people to analyze a certain workbook and add insight. The insight may be as simple as marking a certain area in the workbook and pointing people’s attention to it and it may…

0

Using SetParameters with the Excel Web Services APIs

One of the new methods I listed in the post about new features is the SetParameters() SOAP call. This allows callers to set multiple parameters at the same time in Excel Services. In this example I have a simple list containing items and sales of those items. I then use a PivotTable to aggregate the…

2

Using the Web Services APIs to open a workbook for editing and set calculation options

This post is going to be pretty light-weight. It will show how to use the OpenWorkbookForEditing and SetCalculationOptions methods. I won’t create some over-arching example – the skills you have in interacting with sessions in Excel Services are the going to be the same. I will discuss the behavior and what one can expect. OpenWorkbookForEditing…

2

What’s new in Excel Web Services in SharePoint 2010

So far I talked about the new extensibility features in Excel Services 2010 – REST and the new JavaScript OM. I thought I would spend some time talking about the existing extensibility mechanism we have – Excel Web Services. With the new release we have added some new functionality to this SOAP interface to the…

3

Introduction to the Excel Services JavaScript OM – Part 3 – writing to the workbook

So far we saw how one can call into the EWA at arbitrary times and respond to events by affecting the page around the EWA. This time around we will combine the two mechanisms to make modifications to the workbook when the selection changes. If you will recall, in part 1, we listened to events…

2