One of the things that were a side-effect of the massive re-write we did on the Excel Web Access component (EWA) to enable editing scenarios and better scrolling was the face that, when in view-mode, we could allow the user to type directly into the cells Read More...

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

This post shows how to code the sample application shown on this blog. This continues part 3 of this coding series. In this series, I tried to show how you can play with multiple technologies to achieve your goal. In this case, this “app” uses the following Read More...

This post shows how to code the sample application shown on this blog. This continues part 1 of this coding series. Before we go into the code of the sample app , I will explain the flow of the web part page. The previous post showed the building of the Read More...

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

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

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

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