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
- 8608 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 is data driver in qtp?
What are metrics and matrix?
What VBScript operators, functions, and statements do you use in QuickTest Professional?
How to create runtime property for an object?
Hi frens! I am testing VB project with MS Access database. At add button click my record is storing in data table and it is shown in datagrid. So at Delete button click i want to check datagrid rows 9before and after delete). so how can i do it using descriptive programming?
What are the different types of recovery operation?
Problem with XML checkpoint in QTP ?
Tell me about your project? please help me how to tell about insurance project
How we can use the database checkpoint on a java web based application in which the database connectivity is done using JDBC->Pure Java type (in this type there is no need to create a DSN). At present in QTP we can fetch database values using checkpoint only through DSN. Is there any programming for this if we don't have DSN (ODBC)
how to evalute defects in QTP script?
What is checkpoints for quicktest professional?
How can i initiate the objects to find uniquely in OR
Please Don't mind .i want in detail the real time process i.e in each document what it contains.
How can i use virtual objects? If have i created one new virtual object in a virtual object manager by following instructions.
When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.
