How to extract colored cell value in an excel

Help Studio
, ,
1

In a column I have colored cell values I want to extract that particular value how can I do that. Can anyone help me please.

2

@Chandini_Roy

you have get cell color activity which you can use here…if you dont find the activity from the activities panel → Click filter icon → Select classic and then search

cheers

3

@Chandini_Roy,

As per the data it seems you are trying to get duplicate values. You can read the full range using Read Range activity and then use below expression in assign activity to get list of the duplicate rows.

Dim allDuplicates As List(Of String) = dt.AsEnumerable().GroupBy([Function](dr), dr.Field(Of String)("VMDList")).Where([Function](g), g.Count() > 1).SelectMany([Function](g), g).ToList()

Answer from here: Finding duplicate items in a datatable - #4 by bcorrea

Another solution you can try this.

Thanks,
Ashok :slight_smile:

2 Likes
4

it can be help to you

The image shows a UiPath workflow for reading an Excel file, iterating through each row of a data table, determining the row index, and writing the index to the output. (Captioned by AI)
The image shows a UiPath workflow for reading an Excel file, iterating through each row of a data table, determining the row index, and writing the index to the output. (Captioned by AI)1153×719 33.7 KB

This image shows a UiPath workflow for iterating through rows in a DataTable, getting the row index, and fetching the color of a specific cell in an Excel sheet using the calculated index. (Captioned by AI)
This image shows a UiPath workflow for iterating through rows in a DataTable, getting the row index, and fetching the color of a specific cell in an Excel sheet using the calculated index. (Captioned by AI)1153×719 31.7 KB

5

Hi, If I use this I am getting output as while color only for all cells even though it is red colored in 12th & 13th cells. Can you please help me. Also here issue is if it is red color I should fetch value not only cell color.

6

Yes, you can use only white cells. If the cell values ​​are not equal to white. You can use this

7

I didn’t got. Here my scenario is only red colored cell values i should fetch but if i use above logic i am getting output as white color.

8

@ashokkarale Here I am getting all duplicate values but i want only red colored cell value.
Can you help me please.

9

@Chandini_Roy It is work well. Its clear color cells. ıf you want you can clear just white cells

The image shows a UiPath workflow that reads data from an Excel sheet into a DataTable ("dt"), logs the row count, and assigns the row count to an integer variable ("RowCount_int"). (Captioned by AI)
The image shows a UiPath workflow that reads data from an Excel sheet into a DataTable ("dt"), logs the row count, and assigns the row count to an integer variable ("RowCount_int"). (Captioned by AI)1212×697 32.8 KB

The image shows a list of variables in a programming interface, including their names, types, and scopes. (Captioned by AI)
The image shows a list of variables in a programming interface, including their names, types, and scopes. (Captioned by AI)847×170 7.27 KB

This is a screenshot of a UiPath workflow that iterates through each row in a data table, logs row details, and retrieves the color of specific cells in an Excel worksheet. (Captioned by AI)
This is a screenshot of a UiPath workflow that iterates through each row in a data table, logs row details, and retrieves the color of specific cells in an Excel worksheet. (Captioned by AI)790×810 31.3 KB

A UiPath workflow for iterating through Excel cells, checking their color, and logging messages based on the results. (Captioned by AI)
A UiPath workflow for iterating through Excel cells, checking their color, and logging messages based on the results. (Captioned by AI)790×810 36.6 KB

The image displays an automation workflow process in UiPath, involving a conditional check for a specific color, logging an error message if not met, and managing data within an Excel file including deleting specific rows. (Captioned by AI)
The image displays an automation workflow process in UiPath, involving a conditional check for a specific color, logging an error message if not met, and managing data within an Excel file including deleting specific rows. (Captioned by AI)790×810 35.4 KB

This image shows a UiPath workflow for processing an Excel file that involves deleting specific rows and updating the row count. (Captioned by AI)
This image shows a UiPath workflow for processing an Excel file that involves deleting specific rows and updating the row count. (Captioned by AI)790×810 30.9 KB

Main.xaml (26.0 KB)
Data.xlsx (9.4 KB)

11

@Chandini_Roy

I just change if condition

not colorresult.tostring.contains("Color [White]")

Your excel is not working well. Excel Formula not working. Please try a dummy excel with my code

Main.xaml (25.7 KB)