Skip to main content

NAV 2013 R2 - Export To Excel With Font & Color

Hi All,

This post is based on Requirement/ Query of one of my Blog Reader +shital bawage . All Thanks to Shital for the article.


In this article we will discuss how to achieve Export To Excel with Font, Color and Back Ground Color.

Please go through the article and let me know your views and queries as comment to the article.

If you are looking for same solution in Navision Classic Version refer the article.

There are some issues which are resolved in a Separate Article, Please Refer Here For Updated Article for NAV 2013 R2.

Let's Begin.


1. Add Four Fields Custom Font Name,Custom Font Size,Custom Font Color & Custom Background Color in Excel Buffer Table as shown below.



2. Create Copy of Two Standard Functions - AddColumn & GetCellDecorator with New Name-
   > AddColumnWithFonts
   > GetCellDecoratorWithFonts

3. Below are changes in AddColumnWithFonts -
   > Four New Parameter added FontName,FontSize,FontColor,BGColor.
   > Assigned these parameter in the table fields created in Step 1, as shown below.



4. Below are changes in GetCellDecoratorWithFonts -
   > Remove all Exit, not to get return from function as shown below.



   > Added New Code for Font & Color as below.



5. Now Let's change the calling of Decorator Function in Excel Buffer Table. The Function is called in Two Functions Listed Below -
   > WriteCellValue
   > WriteCellFormula
   
Change the Formula as below -
    //GetCellDecorator(Bold,Italic,Underline,Decorator);
    GetCellDecoratorWithFonts(Bold,Italic,Underline,Decorator,"Custom Font Name","Custom Font Size","Custom Font Color","Custom Background Color");



6. Let's Test with a Report for creating a Report with Customer Table.

7. While Exporting data we use AddColumn Function of Excel Buffer Table, now with the extension code that we have discussed we can use both the function i.e AddColumn and AddColumnwithFonts.

8. Below is a Sample Code for Exporting Customer Data -



As we can see above we are using both standard and customized Function. The Customized Function AddColumnwithFonts are being used with diffrent parameter and options.

9. Let's try to execute the Report and See Output.



Hope you find the article useful and it will help you.

You can download the sample discussed above from my SkyDrive or From Mibuso.

File Name - Saurav-NAV.17.10.ExcelFont.rar

Your Comments are awaited.

Regards,
Saurav Dhyani
www.sauravdhyani.com

Comments

Popular posts from this blog

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------

Future - What Next After NAV 2016. Code Name - Madeira...

Hi All, While Browsing web I came across some article which says about next release of Microsoft Dynamics NAV. Let's see the History of Code Names Given to Previous Version  - NAV 2013 - Code Name 'Sicily' NAV 2015 - Code Name 'CRETE' NAV 2016 - Code Name 'CORFU' And as we all know that all these are the Islands.