Data-Driven loop using Excel Spreadsheet.
Hi, Can someone, please tell me why TC doesn't pick up the second row of data from spread sheet when using Data-Driven loop. It keeps picking up the first row even when the first execution in c...
Forum Discussion
Try this code:
Ppath = Project.Path
set ddtobj = DDT.ExcelDriver(Ppath & "User_Info\plan_user.xls","infotwo")
Do While ddtobj.EOF = False
'Actions
ddtobj.Next
loop
Call DDT.CloseDriver(ddtobj.Name)
set ddtobj = Nothing
Ppath = Project.Path
set ddtobj = DDT.ExcelDriver(Ppath & "User_Info\plan_user.xls","infotwo")
Do While ddtobj.EOF = False
'Actions
ddtobj.Next
loop
Call DDT.CloseDriver(ddtobj.Name)
set ddtobj = Nothing
