March 2006 - Posts

• Short Session Timeout and Session Timeout in Excel Services - Part 1

  This is the first of two posts about Session Timeout and Short Session Timeouts in Excel Services. This first post discusses what the two timeouts are used for. Read More... Posted Friday, March 31, 2006 9:30 AM by Shahar | 3 Comments Filed under: Excel Services

• How does getting and setting ranges from Excel Services work

  Ever wonder how the GetRange family of methods work in the new Excel Services product? Here is a short explanation complete with C# and VB.NET code samples. Read More... Posted Thursday, March 30, 2006 8:00 AM by Shahar | 4 Comments Filed under: Development, Excel Services

• Getting Formatted vs. Unformatted data from Excel Services

  You may have wondered what that “formatted” parameter means on the various GetXXX methods the Excel Services API exposes. This post will explain the expected behavior when using this Boolean. Read More... Posted Wednesday, March 29, 2006 8:35 AM by Shahar | 0 Comments Filed under: Development, Excel Services

• Don't use the .Url property of an Excel Services proxy for your Workbook Name

  I just got an email about somebody doing this - sure to be a common mistake as people start to use the API more. The .Url property of a Web Service proxy class (the one generated by Visual Studio) is simply where the Web Service is located. In the case Read More... Posted Tuesday, March 28, 2006 11:05 PM by Shahar | 0 Comments Filed under: Development, Excel Services

• Information about the various Excel Service API calls to get info from and to Excel Services

  Excel Services supplies eight different methods for accessing and setting data in a workbook to allow the developer to choose which one fits her needs the most. Read More... Posted Tuesday, March 28, 2006 12:00 PM by Shahar | 3 Comments Filed under: Development Related, Development

• As promised, the VB.NET example for the Programming against Excel Services APIs post.

  Excel Services 2007 API usage primer - the VB.NET version of the example posted on Friday. Read More... Posted Monday, March 27, 2006 9:45 AM by Shahar | 0 Comments Filed under: Development, Excel Services Attachment(s): Blog_VB_HelloWorld.zip

• Code snippets that will help with using Excel Services APIs.

  Snippets for working with Excel Services API. Read More... Posted Monday, March 27, 2006 7:34 AM by Shahar | 0 Comments Filed under: Development Related

• First "Hello World" code sample with the Excel Services APIs!

  Primer for working with Excel Services by using the Web Services APIs it exposes. Read More... Posted Friday, March 24, 2006 9:03 PM by Shahar | 87 Comments Filed under: Development, Excel Services Attachment(s): Blog_HelloWorld.zip

• Just finished giving the Excel Services DevCon demo.

  Just finished doing the DevCon demo together with Danny Khen. People seemed to really like what we showed them. In the next couple of days I will start adding a lot of the stuff we showed there to the blog with step-by-step instructions on what things Read More... Posted Thursday, March 23, 2006 4:57 PM by Shahar | 1 Comments Filed under: General, Excel Services

• Tracing exceptions - guidelines

  Some very basic guidelines on how to trace exceptions. Read More... Posted Thursday, March 23, 2006 9:10 AM by Shahar | 0 Comments Filed under: Development Related

• Office DevCon and a lifted NDA.

  Well, when I first started writing this blog, I told you that I am going to post about Excel Services as soon as the NDA is lifted. As you probably know if you are accessing sites that have MSDN in their names, the NDA was lifted and we can now talk about Read More... Posted Wednesday, March 22, 2006 7:21 PM by Shahar | 0 Comments

• Advanced Debugging Part Two – TracePoint Macros that continue execution

  How to use Macros in TracePoints to break/continue your program. Read More... Posted Wednesday, March 22, 2006 8:30 AM by Shahar | 0 Comments Filed under: Development

• Be careful when debugging Visual Studio 2005 created Web-Apps

  While fixing a bug (I have to do that every once in a while. It’s in the contract. I think), I needed to make use of the IsClientConnected property of the HttpResponse object in a WebService sort of project. After trying various things, I still could Read More... Posted Tuesday, March 21, 2006 3:23 PM by Shahar | 0 Comments Filed under: Development Related

• Advanced Debugging Part One - Cross-function breakpoints

  In my ever continuing quest of trying to abolish the need for use of Windbg for application debugging, I keep trying to find various debugging techniques using the VS2005 debugger. Part one of this series contains instructions on how to have advanced Read More... Posted Monday, March 20, 2006 2:33 PM by Shahar | 3 Comments Filed under: Development

• Eliminating CLR bugs in the Whidbey ListView (Virtual mode)

  I discussed using a ListView control in virtual mode in a previous post. When using the ListView control in virtual mode, there are two bugs that can make working with it a bit of a pain. At the end of this post, I have placed a class called SafeListView Read More... Posted Saturday, March 18, 2006 4:11 PM by Shahar | 5 Comments Filed under: Development

• Whidbey Form Designer crashes with inherited form due to asynchronous events

  I am porting some code from 1.1 to 2.0 and ran into this problem. After debugging devenv a bit I was able to get a handle on what's going on. When you have an inherited form in the designer, you should make sure that you do as little as possible in it. Read More... Posted Tuesday, March 07, 2006 1:03 AM by Shahar | 0 Comments Filed under: Development

• Using the CLR 2.0 Virtual List View

  How to use ListView in virtual mode. Read More... Posted Monday, March 06, 2006 10:59 AM by Shahar | 15 Comments Filed under: Development