Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Friends,
I'm new to QTP.
I want to write a function in QTP for below senario.
In an Excel sheet column B, I Have 10 Url/Links, and in
Colum A there is a Flag as Y and N.
My test should run only on those iterations which are
flagged as Y.
Please help, Thanks
- 6 Answers
- 8175 Views
- I also Faced
- E-Mail Answers
Answer Posted / manju
'path of the excel file is - path
'excel file name is abc.xls - columns flag & urlxl
'sheet name of the xl file where the url's are present
is "list"
datatable.addsheet("Urllist")
datatable.importsheet("path abc.exls","list","Urllist")
count=datatable.getsheet("Urllist").getrowcount
for i = 1 to count
datatable.getsheet("Urllist").setcurrentrow(i)
flg=datatable("Flag","Urllist")
if flg='Y' Then
url=datatable("urlxl","Urllist")
systemutil.run("url")
End if
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of parameterization ?
1.Qtp suppots Unix& linx or not 2why qtp suppots shell script.
How software automation specialist enter steps in the Expert View?
how to prepared for first for the first interview?
How to define array in qtp?
What is checkpoints for quicktest professional (qtp)?
how will you load the test cases in ddt?
What is the registration process and examination fees?
i'm testing the webpage with QTP, in this wabpage i have to choose the CV from the window, but QTP can't recognize the object, so i used the Low LEvel Recording, but every time i run the test, QTP go to halt when it gets to the Recorded part, any solution for that?( except puting delay in the script and manuall selecting, because i've did that)
Difference between test object and run time object?
What is the difference between run time object and test object?
To which environments does quicktest professional (qtp) supports?
Can U Explain about QTP tool from older version to latest version also its differences?
Is qtp supports uni-code?
How to get Traceability matrix from TD?
