How to set cell color in excel on exporting from navision

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.

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,


Start on MSDN.

Hi Karthik,

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

Hi Matt. Nice piece of advice. Thanks