Subscribe: Cum Grano Salis
http://blogs.msdn.com/cumgranosalis/rss.aspx
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
access  code  download  excel services  excel  favorites  quotes sheet  ranges  rest  services rest  services  sheet  single quotes   
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Cum Grano Salis

Cum Grano Salis





Last Build Date: Fri, 24 Jul 2015 05:26:06 +0000

 



How to treat spaces/single quotes in Sheet names in REST

Tue, 05 Oct 2010 11:37:44 +0000

When using REST to access portions of a workbook, people sometimes use direct addressing (Sheet1!A1). I thought I’d drop a line about the icky way this works when you have single quotes in your sheet name. Reminder… First – a short reminder. This is how Excel Services REST works when trying to access a range:...



It’s been a while… Welcome Windows Live Embedding!

Thu, 23 Sep 2010 16:31:35 +0000

This has been a long time coming. But I finally have something new for you guys. It has been all over the news/twitter/blogs by now, but one of the new features we added is the ability to embed Excel workbooks in your blogs/sites. There’s a pretty straightforward explanation about this here: Embedding Excel Web App...



Restplorer – visual exploration tool for Excel Services 2010 REST capabilities

Wed, 17 Feb 2010 13:59:28 +0000

At the beginning of the year, I wrote a little web app that lets you get embed code for REST URLs/elements in Excel Services in a very easy way – instead of crafting the URL yourself, or navigating through ATOM feeds, you get a nice UI to do that. Well.. Not really “nice” as much...



Excel Services Gadget download

Tue, 16 Feb 2010 08:13:00 +0000

This is the download page for the Excel Services gadget described in these set of posts. (Download link is right below this line - where it says "Attachments:") ExGadget.gadget



“Scratch pad” mode in Excel Services 2010 – how to bring it back

Mon, 08 Feb 2010 09:00:00 +0000

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 fact that, when in view-mode, we could allow the user to type directly into the cells of the workbook (as opposed to the way we...



Charts based on dynamic ranges in Excel Services 2010

Tue, 02 Feb 2010 13:52:00 +0000

Hey folks, been asked about this a few times already, so thought I would post – if you are using any of the betas, you will notice that your charts based on dynamic ranges that used to work in 2007 no longer work. This has been fixed and will be available in the RTM bits....



How to get favorites listed when searching in the Start menu

Tue, 05 Jan 2010 11:22:56 +0000

There aren’t many Vista features I am missing in Win7, but one that I most definitely miss is having favorites appear when searching the start-menu. Now, you can add a favorites menu item to Start, but that’s not all that helpful for me – what I want is to be able to search in the...



You can access arbitrary ranges via REST – here’s the trick

Tue, 29 Dec 2009 13:24:23 +0000

Reader JJDE asked in this post if it was possible to access arbitrary ranges with REST – you just need to use a pipe character where you would usually place a colon: http://tsdlt2/_vti_bin/ExcelRest.aspx/Docs/Bugs.xlsx/Model/Ranges('Sheet1!A1|Z100') This will return the Sheet1!A1:Z100 range. As for why we had to do this.. IIS does not like colons in the path...



So what else can OpenXML + ASPX + Excel Services can do?

Tue, 15 Dec 2009 09:22:00 +0000

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 presented, at least from a performance point of...



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

Mon, 14 Dec 2009 08:49:00 +0000

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 group. When I saw this post, I decided...