How to export color coding to excel?

Hi

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

Solution

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.


Regards

-PJ-

Solution

Hi Pramod,

Do you know how we can change the font-color of text in cell?

Thanks and Regards,

Suraj Borade

Hi Suraj,

I can see the  action SetFontStyle in the image you attached , did you tried that one ?


Regards,

-PJ-

Hi,

Can someone suggest where are CellRangeFormat and SetFontStyle actions in Excel_package.

Thanks,

Ronan T.