This is a real-world scenario - you need to implement some sophisticated manipulation of Excel tables in VBA, and then you need to extract the data from the Open XML spreadsheet using the Open XML SDK. This screen-cast was based on a real-world project...

This is the fifth in a series of screen-casts on getting started with Open XML development. In this screen-cast, I discuss some of the most important developer techniques that you can use with Open XML development. The simplest technique is modifying...

Quick techniques for finding the Open XML that you need....

Learn how to take advantage of using ISO dates in spreadsheets

...

This is the sixth in a series of screen-casts on getting started with Open XML development. In this screen-cast, I continue the discussion about some of the most important developer techniques that you can use with Open XML development. In this screen...

If your company uses one specific Office theme for one reason or another, you can enable higher fidelity transformations from Open XML WordprocessingML to Html. You can configure the HtmlConverter class to use the styling of one of the Office themes in...

At last I have put together an example that shows the full range of cell style options available in SpreadsheetML. This example will show how to apply a huge variety of styles using very simple code. The video explains how to use the code and also how...

This will probably be the final installment of this series. In this example, I complete the pivot table creation process by configuring the fields that will appear in the rows, columns, filters and data values. This example builds upon the earlier examples...

The members of the Open XML Formats Developer Group represent a wide variety of organizations, but they all have one thing in common: they're excited about working with the new formats. Here are some quotes from the founding members of the Open XML Formats...

Today at the Bio-IT World Magazine World Life Sciences Conference + Expo, Microsoft announced the formation of the BioIT Alliance, a cross-industry group working to further integrate science and technology as a first step toward making personalized medicine...

This sample project shows how to extract embedded objects inside Open XML documents. The example here, written in C# and .NET, shows how to work with an Excel object embedded in a Word 2007 document. Contributed by Stephen Peront of Xinnovation....

01/31/06, Cupertino, California. The second face-to-face meeting of the TC45 committee was hosted by Apple, with 22 members attending....

03/21/06. It's official: we're now live! We have 40 members already signed up — the founding members in the announcement below — and the doors are open to anyone who wants to join! This article tells you all the details about what to expect and how to participate....

11/21/05. Microsoft's decision to standardize on the Open XML Formats for the next release of Office was based on a variety of criteria from Office developers and users. Brian Jones explains some of the thinking behind the decision....

12/15/05, Brussels, Belgium. Apple, Barclays Capital, BP, the British Library, Essilor, Intel Corporation, Microsoft, NextPage Inc., Statoil ASA and Toshiba join together to form TC45, the Ecma technical committee that will draft the new Open XML standard....