Skip to content
Microsoft Dynamics 365

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

This is an update to that blog. You can download updated sample objects from the link below

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

xlt.fob

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!