What is the Most / More Effective Way for this DataTable case?

Hi Everyone,

I have an excel file with more than 1000 rows and columns. I want to check the dataTable contains 7 consecutive “X” for the items in each row.

I can do this algorithmically by increasing and checking the index but I don’t know if this is the most effective way. I am curious about your advice on how to do it most/more effectively

Thanks for advice.


I assume the UiPath for each row takes a lot of time completing the task. I would just write a vba macro that does the check and then use the “Invoke VBA” Activity, trust me that would take a few seconds to complete the task, macros are super fast.

You could use Regular Expression by converting the data table to text and then using Regex.Matches method.