Browse by Tags

• CompatibilityChecker
• Development
• Development Related
• EwaCompanion
• Excel
• Excel Services Gadget
• Geekdom
• General
• JSOM
• REST
• Win7

• 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

• Creative workarounds – Windings edition

  In older posts, I have talked about a developer working on internal Microsoft application who really gives Excel Services a run for its money. Sergei has “starred” in two other posts and after playing for a bit with REST, has come up with a really nice Read More... Posted Wednesday, November 18, 2009 9:00 AM by Shahar | 0 Comments Filed under: Geekdom, Excel Services, Excel Services Gadget Attachment(s): SergeiMagicalWorkbook.xlsx

• Excel Services REST limitations

  We just went through two or three weeks worth of posts and I tried to show you some of the new stuff we can do with Excel Services. It’s cool, it’s exciting, it’s great. But here comes the caveat post!! There are a number of things that do not currently Read More... Posted Tuesday, November 17, 2009 9:00 AM by Shahar | 0 Comments Filed under: Excel Services, REST

• Coding the Excel Services Windows 7 Gadget – Part 5 – Next steps

  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 Read More... Posted Monday, November 16, 2009 9:00 AM by Shahar | 1 Comments Filed under: Excel Services, Excel Services Gadget

• 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

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

• How to seamlessly embed data from Excel Services spreadsheets into Word

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

• Bringing it all back home – using advanced REST functionality with the Excel Services Gadget

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

• Advanced Excel Services REST API capabilities – passing parameters to a spreadsheet

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

• Showing Excel ranges in the Excel Services Gadget

  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 Read More... Posted Wednesday, November 04, 2009 2:27 AM by Shahar | 0 Comments Filed under: Excel Services, Win7, REST, Excel Services Gadget

• Introducing the Excel Services Windows 7 Gadget

  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, Read More... Posted Tuesday, November 03, 2009 9:00 AM by Shahar | 5 Comments Filed under: Excel Services, Win7, REST, Excel Services Gadget

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