+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Data Driven Issue (/Thread-Data-Driven-Issue)
Data Driven Issue - karanth - 03-18-2008
Hi All,
I have one question. Suppose I have a screen which has a Username , Password , Ok Button.
I have an Excel sheet with 50 Username and Passwords.
I have to data drive it, and each values in the text boz itself.
Like if i data drive the frist one , i have to see the values inside the text boxes.
Can anyone help me out , if i get code thats great [ coz Ankur has said we should be sending code ]
Thanks in advance.....
RE: Data Driven Issue - karanth - 03-18-2008
i monor correction....i meant [ coz Ankur has said we should NOT be sending code ]
RE: Data Driven Issue - newqtp - 03-18-2008
Use datatable.Import("c:\user.xls") 'this is path for your xls file which 'contain user name and password.
And in your code
Code:
browser("browser").Page("page").wededit("...").set "UserName" 'here'write the column name which contain user id. same for password.
Hope this will help.
RE: Data Driven Issue - sreekanth chilam - 03-19-2008
Hi Karanth ,
Just check with the sample given below:
Code:
datatable.Import("c:\user.xls")
rcount=datatable.getrowcount
for i=1 to rcount
datatable.setcurrentrow(i)
systemutil.run "your appl url path"
browser("browser").Page("page").wededit("...").set datatable("uname",dtglobalsheet)
browser("browser").Page("page").wededit("...").set datatable("pwd",dtglobalsheet)
browser("browser").Page("page").wededit("...").WebButton("OK").Click
browser("browser").Page("page").close
Next