Process only green highlighted data

Help Activities
,
#1

Hi All, I need to filter only green highlighted rows and process those items. How to do so. When I read range the excel I cant read it’s cell colour right. I also don’t think that I can use filter data table. Please correct me if I’m wrong.

#2

Hi @Archana_N_L

There is no activity to filter rows by color in uipath
Alternate way is to invoke c# or vb.net or vba

some useful link for vba code which can be invoke for filtering cell by color

Hope it helps you

Regards
Nived N

1 Like
#3

Use read range,
Then loop through each row using for each row
get cell color
Use if condition to check green then add that to a different DT

#5

Hi Nived thank you I’ll check it out.

#6

Could you please tell me the condition what you will give to check the Color green

#7

In the way @sandhya_koilada told
U need to first use get color activitiy in excelactivities to the get the color of cell

Then use if Condition to predict whether the color is green or any other color using if Condition

Hope the idea helps you

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed:

1 Like
#8

Use get cell color activity with the green cell and store that in a variable with system.drawing data type
and then use that variable to check other row colors match with that color in if activity

1 Like
#9

OK dear will try and check. Thank you so much

#10

Hi Nived. Just now I created a new topic on How to handle random pops. Please tell me how to handle a random unknown popup that might arise when we open any web browser. Can we simply use continue on error property or is there any specific method for this.