Browse by Tags

• Development Related
• EwaCompanion
• Excel
• Excel Services
• Geekdom
• General
• Touchy Feely

• Who's Afraid of the big-bad cast operator?

  My previous blog entry (which was completely misunderstood by some people who commented - I blame the fact that English is not my native tongue) reminded me of another poor coding behavior. Just so we don't have a repeat of that last post, let me clarify Read More... Posted Monday, March 24, 2008 9:00 AM by Shahar | 5 Comments Filed under: Development

• Using a Generic return type that does not appear in the parameter list - when to use it

  EDIT: Contrary to what people understood from this post, it is NOT a "Do not use Generics" post - I think Generics are a GREAT addition to the language/framework and I use them all the time. It is against a very specific usage of Generics Short Answer: Read More... Posted Sunday, March 23, 2008 2:15 PM by Shahar | 5 Comments Filed under: Development

• COM Library for Excel Web Services - Use EWS from VBA!

  In the ODC 2008, I gave a demo of how to use Excel Web Services from a VBA client - the demo was basically just a managed library that wrapped a generated Web Services proxy. Since Microsoft no longer seems to supply a SOAP toolkit for office, this is Read More... Posted Wednesday, March 05, 2008 9:00 AM by Shahar | 1 Comments Filed under: Development, Excel Services

• Single-select Dimension member Analysis Services Filter Web Part

  A long long time ago, in a building far far away, two Jedis developers called Sreepada Santhegudda and Sergei Gundorov showed me a solution they came up with for a single-select Analysis Services filter web part . While SharePoint ships with a set of Read More... Posted Saturday, March 01, 2008 9:09 PM by Shahar | 1 Comments Filed under: Development, Excel Services

• Using C# 3.0 Extension Methods to make life easier when using optional parameters in Office PIAs

  Gabhan Berry (read his blog - he has lots of Excel programmability related information in there!) wrote a piece about how to make using optional parameters a little less painful when using C# to program against the Excel (and any other) COM PIA object Read More... Posted Friday, February 29, 2008 9:00 AM by Shahar | 1 Comments Filed under: Development, Excel

• EWA Companion Part 4: Refresh/Recalc functionality

  In the first part of this post series I showed the EWA companion and its various capabilities. In this part, I will delve deeper into the "Automatic Refresh/Recalc" capabilities of the companion. This feature is divided into two parts - refresh and recalc. Read More... Posted Wednesday, August 22, 2007 9:10 AM by Shahar | 1 Comments Filed under: Development, Excel Services, EwaCompanion

• Code Art - like ASCII art, only sucks so much more to create....

  I have made two examples of Code Art - taking a piece of code that does something and placing the text in such a manner that it conveys the idea of the program. The reason it sucks so much more than ASCII art is two-fold: a. It is very hard to do significant Read More... Posted Tuesday, August 21, 2007 6:32 PM by Shahar | 6 Comments Filed under: Development, Touchy Feely Attachment(s): CumGranoSalisCodeArt.zip

• EWA Companion Part 3: Open/Download functionality

  In the first part of this post series I showed the EWA companion and its various capabilities. In this part, I will delve deeper into the "Open" functionality of the EWA Companion web-part. There are a few reasons behind adding the Open command to the Read More... Posted Tuesday, August 21, 2007 9:11 AM by Shahar | 12 Comments Filed under: Development, Excel Services, EwaCompanion

• EWA Companion Part 2: Save As Functionality

  In a previous post I discussed the EWA companion and how to set it up for saving back to SharePoint. This post will show the next set of capabilities which is the ability to Save As (actually, it exports or saves under another name - the new workbook Read More... Posted Monday, August 20, 2007 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services, EwaCompanion

• Introducing EWA companion: A web-part that adds missing functionality to the EWA component

  Download the Ewa Companion Over the past year or so, some requests have been voiced by the community again and again. Some of these related to the EWA, asking for extra functionality that is not there by default. To that extent, I decided to write the Read More... Posted Friday, August 17, 2007 9:15 AM by Shahar | 5 Comments Filed under: Development, Excel Services, EwaCompanion

• Small addition to the Excel Services AJAX library

  Hi, I am doing some work on a new sample (called EwaCompanion, more on that soon). As part of that work, I had to add a few things to the AJAX library and fix a few issues. The main addition is the support for the .refreshAll() method which will execute Read More... Posted Friday, August 10, 2007 9:45 PM by Shahar | 1 Comments Filed under: Development, Excel Services

• Excel Services AJAX Download Page

  This page contains the link to the Excel Services AJAX JavaScript download. Read More... Posted Friday, August 10, 2007 1:55 AM by Shahar | 5 Comments Filed under: Development, Excel Services Attachment(s): ExcelServicesAjax.zip

• Image Resizer for Vista (and XP) - Just a right click away from Explorer.

  You can download the resizer here . I don't know about you, but I am sorely missing the XP toy for image resizing. Windows XP had its power-toys, but Vista does not. And while some functionality has been baked into the shell, explorer right-click has Read More... Posted Monday, July 30, 2007 9:09 AM by Shahar | 21 Comments Filed under: Development, Geekdom, Prish Image Resizer

• Image Resizer Download Page

  (Note: When reinstalling, you may need to log off and on after the installation to have everything work properly) 1.0.831.0 - Fixed issues with setting defaults. 1.0.801.0 - Added submenu for resizing quickly. 1.0.0.0 - See initial blog post for more Read More... Posted Sunday, July 29, 2007 2:36 AM by Shahar | 35 Comments Filed under: Development, General, Geekdom, Prish Image Resizer Attachment(s): ImageResizerSetup.msi

• Forum question: Excel Web Services WSDL sans Excel Services

  Now that I can finally answer the forums again, there was a question about how to get to the Excel Web Services WSDL if one does not have MOSS installed. As a public service, I am attaching the WSDL to this post. Enjoy. Note: When creating stubs for Web Read More... Posted Wednesday, June 06, 2007 8:07 AM by Shahar | 2 Comments Filed under: Development, Excel Services Attachment(s): ExcelWebServices.wsdl