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.