Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10 Answers
- 48020 Views
- IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / uday kumar_anem
Here i am sharing a small snippet script, to import the
data from Excel sheet to QTP during runtime and using the
values.
I have an Excel sheet which contains OrderNumber column and
its values. After that i am displaying the order numbers in
excel during runtime.
datatable.Import("E:\Programming Samples\QTP
Samples\OrderNumbers.xls")
datatable.GetSheet(1)
rowCount=datatable.GetRowCount
For i=1 to rowCount
datatable.SetCurrentRow(i)
val=datatable.Value("OrderNumber","Global")
msgbox(val)
Next
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
How do know the number of browsers opened?
How can i get the image text that changes dynamically? Here i have used "GetROProperty", but it's not working. I used like Ex:Browser("webmail").Page("inbox").image ("captchaimage).getroproperty("innertext/text/value")
What is the difference between local and shared object repository in qtp?
Without using gui map editor we can recognize the application in winrunner ?
Hi, I am using 2 excel sheet.First excel sheet works fine with the script, if it opens the 2nd excel sheet,it works fine,but after finish all the rows it is giving the following error in the following line. InValid Procedure call or argument Line (178): "Browser("name:="&result,"application version:=internet explorer 7").Page ("title:=bgt.*", "index:=0").WebList ("name:=SearchType","html id:=Select1","location:=0").Select SearchType1". I have seen a web article says that,If we use any vbscript friendly name it may gives the above error-Invalid procedure call or argument not sure,Am I using any VBScript frienlyName? in the above line? [but the same line is perfecly working for first Excel ] It is little urgent. Any Help Thanks you
What is difference in global and action sheet in qtp?
what is ODC and GDC?
How to interact tool & application build in QTP?
How can you handle exceptions in qtp?
What are the things(properties, and other details) will be recorded while recording an object using normal recording?
is there any addin for remedy user application
In what occasion we can specify global sheet and action sheet?
What are the features supported by UFT?
what is meant by source control?
What is ObjectParamater?
