I am using excel sheet to export data to QTP but it
selects just one row of data from excel sheel how to import
all rows of excel sheet to QTP during runtime
Answer Posted / chivukula.kumar
datatable.Import("E:\Programming Samples\QTP
Samples\OrderNumbers.xls")
colcount = datatable.GetSheet(k).GetParametercount
rowcount = datatable.GetSheet(K).GetParametercount
shtcount = datatable.Getsheetcount
for i = 1 to rowcount step 1
for j = 1 to colcount step 1
for k = 1 to shtcount step 1
datatable.setcurrentrow(i)
val =datatable.Getsheet(k).GetParameter(j).ValuebyRow(i)
next
next
next
Note : the above script for entire workbook values we can
get .
next
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How many types of trigger events are there in qtp?
How many tabs are available in debug viewer pane?
Can we record using all the modes in a single script? Explanation with example is appreciated
How is UFT 11.5 version different from UFT 12.0?
can u explain relative path architecture framework in qtp?
What is Port testing. Whhen will you perform?
terminal services client
Explain object spy in qtp.
How did you resolve conflicts present in Object Repository?
Can any one tell me how to write a script for selecting open option in File menu of A word document.here you have to add objects to OR.try like that and give me the ans.i asked this question to so many but no one knows.if any one know the answer plz let me know
how to evalute defects in QTP script?
What are the advantages of parameterization ?
Describe how Smart Identification is used
How do Parameterization and Data-Driving relate to each other in QTP?
What are the different attributes used with regular expression?