Read color on every written row in excel

Help
, ,
1

Hello Guys, I need an flow which reads an excel file and checks row by row if every written row has a specific background color. Thanks!

3

Hi @Ionut_Frincu - Try to use Get Cell Color activity.

Thanks,
AK

4

Hi @Ionut_Frincu

Scenario
1.Use Excel Application Scope
2.Use Read Range
3. Use Foreachrow
4.Iterate in the foreach row and use Get cell color
5.Then check if you got color or not and do your desire

@Ionut_Frincu

cheers :smiley:

Happy learning :smiley:

1 Like
5

image

Hello mate, what should I write in this parameter in order to iterate on every row? Thanks!

6

Hi @Ionut_Frincu

For your reference.

cheers :smiley:

Happy learning :smiley:

2 Likes
7

for iterate on every row you can use the counter
or
you can use index count in foreach row, so it works as a counter only

Thanks

8

Can you please give me an example with counter to iterate through Column A? Thanks :slight_smile:

9

Hey guys, anyone can give me an example on how can I read an row color from an excel file and iterate through each row that has text into it. THanks!

10

Check this

image
image606×1953 60.6 KB

Check the post

Hope this helps

Thanks