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…

2

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…

2

“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 coding series. In this series, I tried to show how you can play with multiple technologies to achieve your goal. In this case, this “app” uses the following SharePoint 2010 technologies: 1. Excel Web Services: Because…

0

“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 the “I found something interesting” app which allows users to analyze workbooks and publish their insights. With the following few posts, I will show how this solution is coded. The first element of the solution is…

0

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 tried to figure if there was a shortcut. A quick search did not find anything, so I just played with it a bit. Apparently Ctrl-Shift-Enter allows you to run things as admin both from the run dialog…

0

Sample application “I found something interesting”

Another week, another app (and I use “app” loosely – it’s a SharePoint web-part page). The following sample application is used to allow people to analyze a certain workbook and add insight. The insight may be as simple as marking a certain area in the workbook and pointing people’s attention to it and it may…

0

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 content part Click on the “Add Part” when in design mode in a web-part page and choose from Category “Media and content” and from “web parts” choose “Content Editor”: Then click the “Add” button on…

1