Cum Grano Salis

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...

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...

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...

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...

This post shows how to code the sample application shown on this blog. This continues part 1 of this coding series. Before we go into the code of the sample app , I will explain the flow of the web part page. The previous post showed the building of...

The last 20 posts or so on the blog discussed the new Excel Services programmability capabilities – I went into detail on most of them. I hope I was able to convey some of the new and exciting (I am allowed to use this word when I really believe it!)...

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...

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...

This post shows how to code the sample application shown on this blog. This continues part 2 of this coding series. In this stage, I will show how the link we generated in the previous link causes the page to show correctly to the user. In the previous...

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...

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...