QTP and Excel

[Rajashekar Gouda]

Hye Sonia,
The solution for ur question is quite simple.please use the below code with some modifications.

Code:

Datatable.ImportSheet "path.xls","Action name","sheet name"
'action name and sheet name must be same
num=datatable.GetSheet ("action name").Getrowcount
msgbox (num)
For i=1 to num
DataTable.GetSheet("action name").SetCurrentrow i
Browser("sdfs:=sdf").page("sdf:=dse").WebEdit("sdfee:=sd").Set datatable("user_ID",dtLocalSheet)
'use_id is a column in exl sheet
Browser("sdfs:=sdf").page("sdf:=dse").WebEdit("sdfee:=sd").click
Browser("sdfs:=sdf").page("sdf:=dse").WebEdit("sdfee:=sd").Set datatable("password",dtLocalSheet)

Browser("sdfs:=sdf").page("sdf:=dse").WebEdit("sdfee:=sd").click

Next

Pls let me know ur results

Regards
Raj