I’ve put together a screen-cast that shows how to query an Open XML spreadsheet using LINQ from VB.NET. If you are using VB, this is a super-easy way to extract data from SpreadsheetML.
You can find the code at OpenXMLDeveloper.org.
I’ve written a blog post and recorded a screen-cast around table markup in SpreadsheetML. It is pretty easy to create a worksheet, populate cells in the worksheet, and then convert the cells to a table. Tables in Excel 2010, as you probably know, look like this:
Here is the screen-cast that explains table markup, and walks through creation of a small Open XML SDK program that converts ordinary SpreadsheetML cells into a table:
Today, in response to a question at OpenXMLDeveloper.org, I put together a 7 minute screen-cast that shows how to create a protected spreadsheet with locked and unlocked cells. Similar to the screen-cast that I presented in How to Research Open XML Markup, this screen-cast also is a good example of the approach that I take to research Open XML markup.