A while a go we posted a blog decribing how to make some basic customizations to style sheets used for export to Excel.
http://blogs.msdn.com/nav/archive/2009/02/18/customizing-style-sheets-for-ms-excel.aspx
In addition to changes described there (customizing font styles, conditional formatting and adding totals), this will allow adding some basic document properties, choosing to display zero decimal fields as blank, and adding header and footer to the exported document. In addition, code changes added here would allow user to run send to excel, apply described customizations directly in exported document, then import the document to automatically generate customized style sheet. The objects are attached.
These postings are provided “AS IS” with no warranties and confer no rights. You assume all risk for your use.
All feedback regarding issues or suggestion to this post are very welcome!
Jasminka Vukovic (jvukovic), Lars Lohndorf-Larsen (Lohndorf)
Microsoft Dynamics NO
Microsoft Customer Service and Support (CSS) EMEA