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!
Hi @Ionut_Frincu - Try to use Get Cell Color activity.
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
Hello mate, what should I write in this parameter in order to iterate on every row? Thanks!
For your reference.
for iterate on every row you can use the counter
you can use index count in foreach row, so it works as a counter only
Can you please give me an example with counter to iterate through Column A? Thanks
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!