I have an problem. I have written a script,
DataTable.Import("G:\text1.xls")->path of the excel file & name
DataTable.SetCurrentRow("1")-->set current row as 1
For login_id = 1 to 4 step 1
a=DataTable.Value("login_id")-->row name in excel file
DataTable.SetNextRow-->move to the next row
When i run this script it shows all the data one by one that i wnat but the problem is that is runs four times as i want it should run only one time.
You might have used global datatable. Keep the data in local action sheet and run. Hope it wil do wat u need.
Set Test > Settings > Run > Run one iteration only.
Use ImportSheet inplace of Import
DataTable.ImportSheet "Path & file Name",Source sheet name, destination sheet name