Read headers from excel and change their color

I have to read all the headers of the excel file and change the color, if header color is red.

1 Like

Can you show some details of your issue like puttting some screenshot or what will happen if header color is red Thanks :smiley:
@shoaib2

cheers :smiley:

Happy learning :smiley:

Hi @shoaib2

Use Excel application scope and use read range and then use set range Color activity

Thanks
Ashwin.S

Hi @shoaib2,

Inside Excel application scope, use Get Cell Color activity to get colour of the cell and set range Color activity to set the colour of cell.

Thanks

1 Like

There is an alternative to do so, check this video:
https://www.youtube.com/watch?v=AhSZy5wKSp4