Archive for November, 2006

Free Book: Learn C#

A quick and easy online guide to C#. Also comes with a short preview of the changes C# 2.0 brings.
Learn CSharp

Add comment November 22nd, 2006

From Excel spreadsheets to persuasive presentations

CX NOW! is a powerful dashboard tool from BusinessObjects. Check out their demo. Prices start at 195$

Add comment November 13th, 2006

Excel as a database, Part 2

Neopoleon : Excel as a database
“As a developer, you’ve probably, at some unfortunate point in your life (possibly several points, actually), been handed an Excel file that has been crammed full of “data” by someone in marketing and told to “do something with it.”"

1 comment November 8th, 2006

A tale of Excel

“Bill Gates was amazingly technical. He understood Variants, and COM objects, and IDispatch and why Automation is different than vtables and why this might lead to dual interfaces. He worried about date functions. He didn’t meddle in software if he trusted the people who were working on it, but you couldn’t bullshit him for a minute because he was a programmer. A real, actual, programmer.”
Joel Spolsky writes a very interesting essay on software development, management and, of course, Excel.

My First BillG Review

Add comment November 8th, 2006

Why you shouldn’t use Office Automation

A short note from the author:
Considerations for server-side Automation of Office
“Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when run in this environment.

If you are building a solution that runs in a server-side context, you should attempt wherever possible to use components that have been made safe for unattended execution, or find alternatives that allow at least a part of the code to run client-side. If you choose to use an Office application from a server-side solution, you will find that it lacks many of the necessary capabilities to run successfully, and you will be taking risks with the stability of your overall solution.”

Further incentives on quitting Office Automation would be useless.

Add comment November 8th, 2006

5 reasons why Excel 2007 is better. Or not.

5 reasons why Excel 2007 smokes the web2.0 competition… and why it may not matter is an interesting peak into the improvements Excel 2007 is supposed to bring in December. ZuluInSiliconValley points out

  1. Conditional Formatting
  2. More rows
  3. Previewing
  4. Ribbon and menu bars
  5. Charting

vs

  1. Sharing
  2. Search

Add comment November 8th, 2006


Calendar

November 2006
M T W T F S S
« Oct    
 12345
6789101112
13141516171819
20212223242526
27282930  

Posts by Month

Posts by Category