Most of you will know that Excel 2007 (and 2010 and 2013) comes with a brand new file format, based on what MSFT calls Open XML.
This suddenly enables us to write code that can easily generate/change Office 2007 files without the need for an Office installation. For instance on a server.
Whilst there is proper documentation on this file format, the document with detailed descriptions of the Open XML format ("part 4" in the aforementioned link) counts an astonishing 4721 pages !!
This is why I decided to write up a couple of basic pages on how to do stuff with these Open XML files. We'll start relatively simple.