Check cell color in excel file and handle!

excel

#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


Get Cell Color does not work for conditional formatting
#2

Hey there,
Make use of excel activities.


#3

Hey @longnt23

for your guidance:

Regards…!!
Aksh


#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


#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.