How to set cell color in excel on exporting from navision

Business Central/NAV Developers Forum
1

Hi all,

I want to set cell color in excel when I am exporting data from navision. Can any one please guide me.

Thank you in advance.

2

Hi Kathik,

You will have to use Microsoft Excel Object Library Automation Server, and the Objects of Excel (eg. FillFormat) will be available on code,

Cheer!

3

Start on MSDN. http://msdn.microsoft.com/en-us/library/bb242656%28v=office.12%29.aspx

4

Hi Karthik,

You can write code to fill color by fitting a macro in your excel sheet

5

Hi Matt. Nice piece of advice. Thanks