Importdata and Export results

[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