Office 2007 Open XML File Formats – An interesting read from the ‘new’ MSDN Lite Edition.

http://msdn.microsoft.com/en-us/library/aa338205.aspx

PDC 2009 Next Week!!

 

I am eagerly looking forward to the presentation ‘Future Directions for C# and Visual Basic’.

http://blogs.msdn.com/lucabol/archive/2009/11/13/luca-at-pdc-2009-next-week.aspx

Excel Pivot Tables

Pivot Tables are an interactive table that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. They can sort, count, and total the data, and are available in a variety of spread sheet programs. One advantage of this feature in Excel is that it allows you to rearrange, hide, and display different category fields within the Pivot Table to provide alternate views of the data. Read on to find out how to create your own pivot table in Excel.Found this neat article which illustrates 3 examples.

MVVM Pattern

The most useful pattern for WPF and Silverlight apps.

http://msdn.microsoft.com/en-us/magazine/dd419663.aspx

Microsoft Excel Web Queries

Pulling data from an external website to an Excel spread sheet can be easy with Excel Web Queries. Web Queries fetches html tables from the web page that you specify and lets you select the ones containing data you want to put into your worksheet.

Web scraping without writing c0de that is!!

More Illustrations Here