Importdata and Export results

[shayk1985]

hi,
i want to import excelsheet into my script for which i used the below code;
Datatable.Importsheet "C:\Documents and Settings\Desktop\Excel testdata\Create.xls",1,"Results"
Now problem is my script consists of different functions like
launch browser
login
create retailer
if retailer exist then go to next
elseif retailer does not exist then create
end if
logout
here i want to import the excel and want to take no of iterations like for
i=1 to rowcount in this case where i have to place "next".also i want to create a excel function for importdata and export results so that i can use it for all tests

thanks

[udayanem]

It is all dependent on your Excel Content.

I am hoping the Excel sheet contains "Retailer" information in your case, you have to follow below approach.

Code:

Datatable.Importsheet "C:\Documents and Settings\Desktop\Excel testdata\Create.xls",1,"Results"
Datatable.getSheet("Results")
RowCount=DataTable.getrowcount

launch browser
login
for i=1 to RowCount
Datatable.setCurrentRow(i)
Now write your logic to create retailer etcc...
next

Regards,
Uday