Check cell color in excel file and handle!

Help
1

Hi everyone,
I am looking for a solution to check cell color in excel file.
Example,
In cell range “A1:B5” have background color are “RED” and “BLUE” and “BLACK”. And I check if background color is “RED” I write text in all cell range.

Thank,
Long

2

Hey there,
Make use of excel activities.

2 Likes
3

Hey @longnt23

for your guidance:

image.png606×1953 60.6 KB

Regards…!!
Aksh

1 Like
4

Hi Aksh,

Can you please provide the xaml file as we are not able to see the entire flow.

Regards
Sunitha

5

Hey @Sunitha1

I am not able to locate that file on my system. Might be not anymore on my system :slight_smile:

But you can see the attached sample for your understanding :slight_smile: - Cell_Color_Sample.zip (8.1 KB)

Regards…!!
Aksh

1 Like
6

Hi Aksh,

Thanks for sharing the flow, now I am trying to read the excel data using readRow.
Starting cell would be “A”+Index_of.ToString and storing the output in System.Collections.Generic.IEnumerable<System.Object>.

When i use for each activity to retrieve the elements and when i display in message box it displays all the column values for that particular row.

Now i need to retrieve these values separately and store in a variables.

Please suggest how we can achieve this.

Regards,
Sunitha.

7

Hi @aksh1yadav

Thank you for you brief demonstration. Can you please also demonstrate in case of 38 Columns and 100+ rows. How to check each row’s column color?

Thank you