NAV 2013 R2 - Export To Excel With Font & Color

Administrator

NAV 2013 R2 - Export To Excel With Font & Color
The Objects provides a sample of having Below listed features during Export to Excel in NAV 2013 R2 :

> Using Font as per user requirement.
> Using Font Color as per requirement.
> Using Back Ground Color as per requirement.
> Using Different Font Size for the Exported Sheet.

For Details Please Refer the article - http://saurav-nav.blogspot.in/2015/08/n ... -font.html

Your Comments and feedback are much appreciated.

http://www.mibuso.com/dlinfo.asp?FileID=1669

Discuss this download here.

Kishorm

I think you need to make more changes to the GetCellDecoratorWithFonts function (need to rearrange the statements or check for attributes not being used). The problem is that you have taken out the EXIT statements so it won't always use the correct Decorator, for example if you have Bold and Italic it will end up just using the Italic one (as that appears after Bold and also Bold and Italic).

postsaurav

Hi All,

As I am unable to find upload Option in Mibuso for the Update on the Tool. Please refer below Link for the Updates as Suggested by @Kishorm

saurav-nav.blogspot.in/2016/03/nav-2013-r2-export-to-excel-with-font.html