Dynamics NAV, customizing style sheets for export to MS Excel


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_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 (5)

  1. anastas says:

    Hello, can I use this tool to choose which fields to export to excell and how is it done?

  2. 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

  3. Anastas says:

    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.

  4. 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

  5. Anastas says:

    Yes, I suppose that this could do, but it will be nice if you manage to add it to the tool one day 🙂

Skip to main content