+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Others (https://www.learnqtp.com/forums/Forum-UFT-QTP-Others)
+--- Thread: getrowcount (/Thread-getrowcount)
getrowcount - be_sure - 10-16-2008
Extracted Code :
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.
RE: getrowcount - be_sure - 10-21-2008
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.