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!
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
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
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
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
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
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
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?
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
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…