Extracted Code :
-------------
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.
Code:
Dim IntNumberOfIterations
IntNumberOfIterations = DataTable.GetRowCount
Msgbox IntNumberOfIterationsThough 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.