I need some help with the ActiveData and ActiveDataRow class.
I have an excel file and would like to loop through specific rows in order to minimize the time needed to run my testcases.
What would your advice be instead of using "For Each row In data" which loops through all the available rows ?
You could try replacing the For loop with, for example "row = data.Item(3)", which should use row 3 of your ActiveData.
Instead of using a for each loop to go over all of the rows in the Active Data asset, you can use the ActiveData.Item() method to return the ActiveDataRow at a given index. The ActiveData.Count property will return the total number of rows in the Active Data asset.
Using both of these, you could probably use a for loop and only use the rows that you're interested in, instead of iterating over all of the rows.
Exactly what I was asking for.
Actually I thought the Item() was a read only property, misread the documentation.
Many thanks to both.