How to export color coding to excel?


I want to generate excel for risks and in excel I want to export color codings of risks and my report will look like this.

How to achieve this?

Please advice.

Thanks and Regards,

Suraj Borade


Hi Suraj,

In Excel package extension you have method to set background color of your cell which you need to use while writing your data in excel.

I did use this in some of my reports and it worked fine.

You can also set font style and border of the cell.