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

How to get favorites listed when searching in the Start menu

There aren’t many Vista features I am missing in Win7, but one that I most definitely miss is having...

Author: Shahar Prish Date: 01/05/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

Creative workarounds – Windings edition

11/24/09 - Correction - Sergei contacted me to explain that I got it all wrong - Windings does not...

Author: Shahar Prish Date: 11/18/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

What’s coming to Cum Grano Salis this week..

Just thought I’d drop a quick note as to what to expect to see this week.. Today there will be a...

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

Next>