Dynamics NAV, customizing style sheets for export to MS Excel

  • Article

A while a go we posted a blog decribing how to make some basic customizations to style sheets used for export to Excel.

https://blogs.msdn.com/nav_developer/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, Lars Lohndorf-Larsen

Microsoft Dynamics NO

Microsoft Customer Service and Support (CSS) EMEA

 

 

xlt.fob

Comments

  • Anonymous
    July 06, 2010
    Hello, can I use this tool to choose which fields to export to excell and how is it done?

  • Anonymous
    July 06, 2010
    Hi, The Export to Excel functionality in NAV exports exactly what you see on the screen, so you just need to have the data you want exported, displayed. What this tool does is, it helps you changing the format (fonts / bold / colours, etc) of what you export. I dont know if this answers your question? Lars

  • Anonymous
    July 07, 2010
    Hello, thank you for the prompt answer. When I export to Excel, I need to export only part of the fields which are on my screen in Navision, as it is with the export tool in Word.

  • Anonymous
    July 07, 2010
    Aha, I see what you mean. The tool won't do that, but what you can do, is: Create an Excel Style which is just white font, so you can't see it. Then use "Conditional formatting" in the tool to apply this style to that field. Then the field is still there, but you can't see it. The header will still be there however. So probably not the best of workarounds. Do you think this is a common request? Then maybe we could think of adding it to the tool sometime in the future (but no promises)... Lars

  • Anonymous
    July 07, 2010
    Yes, I suppose that this could do, but it will be nice if you manage to add it to the tool one day :)