Read headers from excel and change their color

[shoaib2]

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

[pattyricarte (Patty Boy)]

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

cheers

Happy learning

[AshwinS2 (Ashwin S)]

Hi @shoaib2

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

Thanks
Ashwin.S

[Jyotika_Halai]

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

[RAKESH_KUMAR_BEHERA]

There is an alternative to do so, check this video:
UiPath Tutorial | Set the Color in Cell UiPath | Lookup Data Table UiPath | ExpoHub - YouTube

[RAKESH_KUMAR_BEHERA]

UiPath Tutorial | Set the Color in Cell UiPath | Lookup Data Table UiPath | ExpoHub