getrowcount

[be_sure]

Extracted Code :

Code:

Dim IntNumberOfIterations

IntNumberOfIterations = DataTable.GetRowCount

Msgbox IntNumberOfIterations

-------------
Though the excel sheet attached to the script has data in only 84 rows, it shows as 65535 ( all rows in excel sheet). How to solve the solution. No. Of rows keep changing according to scenario, so cannot hardcode as 84.

[be_sure]

Today I have checked with my senior Automation tester, the solution was that delete all rows that are not needed for the automation test. ( I have already done that before but still the problem was there). Then i realised that one of the whole column was shaded with grey colour in all the cells. I cleared the colour in the column, then it worked fine.