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
- 6569 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / murli.me
get data from exel file into two variables for col(A) and
col (B).
get the Flag into a variable
count the no of URL's.
check the condition for the flag if flag=y then repeat the
test for the no of times the URLS are present..
is this right... if not sujjest me the right one please......
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / murli
get data from excel
n=datatable.usedrange.rows.count
for i= 0 to n
a(i)=workbook.cells(i,1)
x=a(0)
y=a(1)
next
if x=yes then
write script
endif
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nil
Thanks Manju and Murli,
After doing bit modifications The above code worked fine
for me....
Please check for my new question whenever u get free time.
Regarding
(How to trap an error message on Web page through QTP.)
Thanks a lot for ur great help :).
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nil
Hi,
Thanks for ur answer :)
I'm sure your answer would be correct. but it would be
great if you provide me code, as I'm not that perfect in VB
scripting.
Thanks Again :))
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the virtual object?
After coming to know that QTP could not identify non-standard objects, we set those non-standard objects as virtual objects using Virtual object wizard. But how can we identify that qtp could not identify non-standard objects?
Who uses qtp tool?
Suppose you are using shared objects repository in your test and you want to split your present action? At that time shared object repository is single or it’s also splits?
How to see the screens after running test in QTP?
How is the Bitmap checkpoint different from Image checkpoint?
Hi, how can we retrieve a specific value from Excel Sheet (Not datatable. for externel file).i mean to say from .xls file. and also tell me from xml file and .doc file. and how can u parameterize ur script from .xls file.(Not data table).
what is life cycle of automation testing ?
I want to configure the OR and library files to a particular QTP test during run time. Note: OR and Library files are located in Quality Center. Is it possible in QTP? Anybody having code?
what is the latest version of QTP? Main difference between 9.2 and 10 version
The Senario is Steps to do 1.Entered userid in textbox 2.saved with details 3.i want to open user which i have created its in hurry.....
How did u write macros?What is the main importance of VB macros in testing environment?
WinRunner 
