Often as a developer you need to write code that creates an Excel document from your database or report. Lots of blogs are already out there that explain how you can get the browser to open up Excel to display your data in columns.
However a sample has just been uploaded that shows how you can leverage Open XML to do additional formatting on the document - such as: setting a page header, freezing the column headings, and row formatting.
This way your users can open a nicely formatted report or other spreadsheet created straight out of your application.
Click here to read the full article.