Loop excel row values based on color

Learner007 · August 29, 2023, 1:01pm

Hi Everyone,

I have data in excel sheet i want to copy those till 1 color as 1 set and another color will be another set. How can i achieve this.

Input :

Output:

I want to loop color vise values

for each loop 1 :

159486
326598
851294
328476
235698

for each loop 2 :

953745
398574
832795
658319
435982

for each loop 3 :

284618
759412
186738

Attachment :

Coumn re arrange(AutoRecovered).xlsx (10.9 KB)

postwick · August 29, 2023, 1:13pm

Use Excel
** For Each Row in Excel
*** get color with https://docs.uipath.com/activities/other/latest/productivity/excel-get-cell-color
*** add the value to a collection, datatable, etc depending on your needs and the color

Learner007 · August 29, 2023, 1:25pm

Hi @postwick I don’t know how many color rows will be available in my sheet. If i go row by row and doing color match it will be lengthy and difficult process i guess but i will try this once. Do we have ant alternate way to do it.

postwick · August 29, 2023, 1:45pm

You could create a datatable with the same columns as the Excel file, plus a row for color. In your For Each Excel Row you use Add Data Row to add the Excel data to the datatable plus the color. Then after that you could loop through the datatable and use Filter Data Table to find all the rows of each color. That would make it so it works even if the colors aren’t all grouped together in the Excel file.

Learner007 · August 29, 2023, 5:11pm

@Vikas_M if you have time please check this also once.

Shiva_Nikhil · August 29, 2023, 5:24pm

@Learner007

try this way you will get all the values

Learner007 · August 29, 2023, 6:23pm

Hi @Shiva_Nikhil , is there any option to do without specifying the color. Because i don’t know what color i will receive there. If it’s possible to pick any colour that will be good. I will check once again if the color format is same then this will be enough.

Shiva_Nikhil · August 29, 2023, 6:26pm

@Learner007

if you are not mentioning the colour it is not possible to

identify the output colour by get cell colour activity

cheers

Learner007 · August 29, 2023, 6:35pm

Ok got it will try that once and i will check about the format of that excel also once

Shiva_Nikhil · August 29, 2023, 6:36pm

@Learner007

ok sure

happy automation

Benjamin_Vazquez1 · August 29, 2023, 7:33pm

Hi @Learner007 I share you one example to do it colors dinamically, I hope it can help you
LoopbyColor.zip (9.9 KB)

Learner007 · August 30, 2023, 9:15am

Hi @Benjamin_Vazquez1 Do you have this code in VB and i’m not using modern design flow also. When i try to create same flow separately it is throwing me error.