There is a whole lot of content (articles, screen-casts, and blog posts) on Open XML.  Over the last couple of months, I have been making a list of as much Open XML content as I can find.  I have found and categorized some 380 pieces of content, and organized them by keyword and author.  Keywords (and author names) in the content list are hyperlinks, so it is easy to navigate around and, for instance, look at the list of Open XML content that pertains to SharePoint, or all of the content associated with content controls.  I have made this list so it is very easy to maintain, so if you are an author of some good Open XML content, please drop me an email (eric at ericwhite.com) and I’ll be happy to include it in the list.  And of course, as I discover (or write) new content, I’ll be adding it to the list.  If you need to find an article or screen-cast that explains how to accomplish some particular task, this should be the first place you start.  Click on the following link to see the content list.  This link will remain the same as I update the list, so feel free to bookmark it.

Open XML Content List

The way that I created this list (and keep it updated) is interesting in and of itself.  I’m maintaining this list as a table in an Open XML spreadsheet.  I used the code that I presented in the post on Using LINQ to Query Excel Tables.  I didn’t have to modify that code at all to make it work with my table in my worksheet.  Then, I wrote some LINQ code to transform the results of the query into HTML tables, with all appropriate links in the right place, and so on.

And of course, I’ll include that article in the published list of content.

This was a work that I did as quick as possible, and I have certainly made some mistakes – included content that perhaps I should not have, or perhaps assessed the technical level (100, 200, 300, 400) incorrectly.  I’ll be updating this list on a regular basis, correcting errors, adding new content, removing content that I should not have, etc.  If you have any tips or points about this content list, please let me know.