Archive for December, 2009

New Tutorial: Iterating Over Excel Rows and Cells

I have created a new tutorial showing an alternative method of reading and retrieving data from an existing Excel worksheet.

ExtremeML Updated for Compatibility with Latest SDK Release

Despite the general enthusiasm shared by most OpenXML SDK users at the release of the latest December 2009 CTP, it introduced a number of breaking changes, which has necessitated some corrective coding within ExtremeML.
This work is now complete and the updated release of ExtremeML (entitled the December 2009 Preview) is now available for download.

Microsoft Releases 4th OpenXML SDK CTP

The much-awaited December 2009 CTP of the Microsoft OpenXML SDK is now available for download.
It delivers a number of new features, including some elegant refinements to its accompanying tools, which are now accessible via a combined interface.
To accompany this release, Microsoft Program Manager Zeyad Rajabi has published a comprehensive discussion of the four key areas [...]

2 New Tutorials: Adding PivotTables and PivotCharts using ExtremeML

Building on my earlier tutorials, which explained a range of techniques for working with programmatically injecting table data into Excel, I have today published to new lessons that explore ExtremeML’s support for PivotTables and PivotCharts.

Adding a PivotTable
Adding a PivotChart