“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

Summary – new programmability capabilities in Excel Services

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!) capabilities we built into Excel…

0

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. This allows callers to set multiple parameters at the same time in Excel Services. In this example I have a simple list containing items and sales of those items. I then use a PivotTable to aggregate the…

2

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 SetCalculationOptions methods. I won’t create some over-arching example – the skills you have in interacting with sessions in Excel Services are the going to be the same. I will discuss the behavior and what one can expect. OpenWorkbookForEditing…

2