Browse by Tags

• Development Related
• EwaCompanion
• Excel
• Excel Services Gadget
• JSOM
• REST
• Win7

• 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 Read More... Posted Tuesday, December 15, 2009 9:22 AM by Shahar | 0 Comments Filed under: Development, Excel Services

• Zeyad Rajabi just got served – Extending the reach of Excel Services with the Open XML SDK – now with more awesomness

  A few days ago, Zeyad Rajabi posted a really nice post about using OpenXML with Excel Services . His solution showed an Excel chart that you use to update a workbook and generate a chart showing, in the case of his example, the status of specs in his Read More... Posted Monday, December 14, 2009 8:49 AM by Shahar | 0 Comments Filed under: Development, Excel Services

• “Something interesting” Sample app – Coding – Part 3 – Showing the interesting stuff

  This post shows how to code the sample application shown on this blog. This continues part 2 of this coding series. In this stage, I will show how the link we generated in the previous link causes the page to show correctly to the user. In the previous Read More... Posted Thursday, December 10, 2009 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services, JSOM

• “Something interesting” Sample app – Coding – Part 2 – coding the publish functionality

  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... Posted Wednesday, December 09, 2009 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services, JSOM

• “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 Read More... Posted Tuesday, December 08, 2009 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services

• 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 Read More... Posted Monday, December 07, 2009 9:02 AM by Shahar | 0 Comments Filed under: Development, Excel Services, JSOM

• 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 Read More... Posted Monday, November 30, 2009 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services

• 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 Read More... Posted Wednesday, November 25, 2009 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services

• 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 Read More... Posted Tuesday, November 24, 2009 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services

• 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 Read More... Posted Monday, November 23, 2009 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services, JSOM

• 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 Read More... Posted Friday, November 20, 2009 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services, JSOM

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

  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 the new JavaScript browser-side OM we are shipping with SharePoint 2010. This OM will Read More... Posted Thursday, November 19, 2009 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services, JSOM

• 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 Read More... Posted Friday, November 13, 2009 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services, Win7, REST, Excel Services Gadget

• 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 Read More... Posted Thursday, November 12, 2009 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services, Win7, REST

• 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 Read More... Posted Wednesday, November 11, 2009 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services, Win7, REST, Excel Services Gadget