Get Cell Color argument for each row iteration

[Ionut_Frincu (Ionuţ Frincu)]

Hello Guys I need to read cell color on each iteration from an for each row loop and I dont know what argument should I set to Get Cell Color. Thanks!

[AshwinS2 (Ashwin S)]

Hi @Ionut_Frincu
give the color variable and print the variable as ColorVar.Name.ToString

Thanks
Ashwin S

[TanVuong (MrErrorRobot)]

Please check this post :

SOLVED - Get Cell Color Function

Hi Can someone possibly assist me with this one, I’ve searched the forums and Googled but can’t find a relevant answer. I wish to use the Get Cell Color function in order to see if a cell is grey. I then want to feed this into a flow decision, so that if the cell is grey it will follow true and follow one process or if false will follow a different process. I use the Excel Application Scope to define the spreadsheet, and then the Get cell colour function within this to retrieve the colour. H…

[gulshiyaa]

Hi @Ionut_Frincu

keep color output variable as system.drawing.color and when your passing that argument use .ToString

cool,
Regards,
gulshiyaa

If you find it useful mark it as solution and close the thread.

[Ionut_Frincu (Ionuţ Frincu)]

Ok, I read this post, but what should I write in GET CELL COLOR argument in my case?

[gulshiyaa]

nothing set a variable and while you passing your variable add .tostring thats it

[Ionut_Frincu (Ionuţ Frincu)]

But what if I want to read ony one column from the excel?

[SrenivasanKanna (Srenivasan kannan)]

I think you are not providing the dynamic part of cell position to read the cell color.

[TanVuong (MrErrorRobot)]

sorry, it’s my bad, i think you can try follow my example:
For each row : row in table
get cell color : “Your sheet” and row(“columnName”)
and create variable with type is color to store result of color.