Cum Grano Salis
How to treat spaces/single quotes in Sheet names in REST
When using REST to access portions of a workbook, people sometimes use direct addressing...
Author: Shahar Prish Date: 10/05/2010
It’s been a while… Welcome Windows Live Embedding!
This has been a long time coming. But I finally have something new for you guys. It has been all...
Author: Shahar Prish Date: 09/23/2010
Restplorer – visual exploration tool for Excel Services 2010 REST capabilities
At the beginning of the year, I wrote a little web app that lets you get embed code for REST...
Author: Shahar Prish Date: 02/17/2010
Excel Services Gadget download
This is the download page for the Excel Services gadget described in these set of posts. (Download...
Author: Shahar Prish Date: 02/16/2010
“Scratch pad” mode in Excel Services 2010 – how to bring it back
One of the things that were a side-effect of the massive re-write we did on the Excel Web Access...
Author: Shahar Prish Date: 02/08/2010
Charts based on dynamic ranges in Excel Services 2010
Hey folks, been asked about this a few times already, so thought I would post – if you are using any...
Author: Shahar Prish Date: 02/02/2010
You can access arbitrary ranges via REST – here’s the trick
Reader JJDE asked in this post if it was possible to access arbitrary ranges with REST – you just...
Author: Shahar Prish Date: 12/29/2009
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...
Author: Shahar Prish Date: 12/15/2009
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...
Author: Shahar Prish Date: 12/14/2009
“Something interesting” Sample app – Coding – Part 4 – Summary
This post shows how to code the sample application shown on this blog. This continues part 3 of this...
Author: Shahar Prish Date: 12/11/2009
“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...
Author: Shahar Prish Date: 12/10/2009
“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...
Author: Shahar Prish Date: 12/09/2009
“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...
Author: Shahar Prish Date: 12/08/2009
Windows 7 useful shortcut – run as admin
It was driving me nuts to right-click/run as admin each time I needed in Windows 7/2008R2. So I...
Author: Shahar Prish Date: 12/07/2009
Sample application “I found something interesting”
Another week, another app (and I use “app” loosely – it’s a SharePoint web-part page). The following...
Author: Shahar Prish Date: 12/07/2009
How to edit the content and HTML in a content-web-part in SharePoint 2010
Thought this may interest some of you (plus, I use it sometimes in my blog posts).. Step 1: Add a...
Author: Shahar Prish Date: 12/06/2009
Summary – new programmability capabilities in Excel Services
The last 20 posts or so on the blog discussed the new Excel Services programmability capabilities –...
Author: Shahar Prish Date: 12/01/2009
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....
Author: Shahar Prish Date: 11/30/2009
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...
Author: Shahar Prish Date: 11/25/2009
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...
Author: Shahar Prish Date: 11/24/2009
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...
Author: Shahar Prish Date: 11/23/2009
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...
Author: Shahar Prish Date: 11/20/2009
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...
Author: Shahar Prish Date: 11/19/2009
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...
Author: Shahar Prish Date: 11/17/2009
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...
Author: Shahar Prish Date: 11/16/2009
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...
Author: Shahar Prish Date: 11/13/2009
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...
Author: Shahar Prish Date: 11/12/2009
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...
Author: Shahar Prish Date: 11/11/2009
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...
Author: Shahar Prish Date: 11/10/2009
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...
Author: Shahar Prish Date: 11/09/2009
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...
Author: Shahar Prish Date: 11/06/2009
Excel Services Windows 7 Gadget
The Excel Services Windows Gadget allows you to display information from Excel Services and place it...
Author: Shahar Prish Date: 11/05/2009
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...
Author: Shahar Prish Date: 11/05/2009
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...
Author: Shahar Prish Date: 11/04/2009
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...
Author: Shahar Prish Date: 11/03/2009
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...
Author: Shahar Prish Date: 11/02/2009
Reason #4871 why I hate DHTML
Margins. In script. To set? Use element.style.marginTop. To get in runtime? Use element.topMargin....
Author: Shahar Prish Date: 10/31/2009
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...
Author: Shahar Prish Date: 10/30/2009
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....
Author: Shahar Prish Date: 10/29/2009
So what does REST on Excel Services look like???
In my first post about Excel Services and REST, I showed how to construct a simple REST URL pointing...
Author: Shahar Prish Date: 10/28/2009
Welcome to the new Excel Services!
Now that Microsoft SharePoint Conference 2009 is done, I have some more time to start posting about...
Author: Shahar Prish Date: 10/27/2009
UlsViewer released
The folks in Office Operations released the Uls Viewer tool – it allows users of SharePoint to...
Author: Shahar Prish Date: 10/13/2009
Optimizing life – Life in Async
I was going to get coffee today at work, minding my own business, when someone from the test-team...
Author: Shahar Prish Date: 07/01/2009
Windows 7 RC – Media Streaming (“Stream” button in Windows Media Player)
I found out about this feature a bit ago and.. Wow.. I am so impressed. The set-up procedure is a...
Author: Shahar Prish Date: 05/07/2009
Prish Resizer moved to another blog (Also, new version – jpg quality support + custom size through context menu)
Image Resizer has moved to another blog – this way it does not interfere with this blog which is all...
Author: Shahar Prish Date: 01/20/2009
What new features would you like to see in Prish Image Resizer?
Now that the x64 issue and the non-latin characters issues are solved, what new features would you...
Author: Shahar Prish Date: 01/14/2009
New version of Prish Image Resizer (x64 support. Unicode support).. It’s been a while..
Well.. It’s been a while since I updated.. Short and sweet – this is the new version of Image...
Author: Shahar Prish Date: 01/14/2009