Is there a way to read an entire column in Excel without have to use For Each Row? I have an excel that has over 2000 or more rows. Using For Each Row will take a lot of time. I just need to locate a row with red cell color and send email alert if any cell with red color is found.
Unfortunattly the best way to do your procedure is to loop through the excel rows and use the ‘Get Cell Color’ Activity. There is no default activity to filter rows by color, at least yet