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 / 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
i have doubt suppose iam purly working in manual, when i will get work to do on sql and performence testing? pls any one clarify doubt?
What is expert view and keyword view?
How does qtp identify gui object?
Define virtual object?
For which type of project the iterative model is suitable?
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object.. (give a filter condition only WEbelement- not easy need to use some more property while giving filter condtions- use google for your help...))
What test you perform mostly? Regression or retesting in your testing process?
How will you declare a variable in qtp?
Why do we use "Text checkpoint" If we can make use of it in "standard checkpoint" ?
how to find that tools work well with ur existing system?
Did the scripts need lot of maintenance? If yes, why?
Does quicktest professional is unicode compatible?
How to use Environment parameterization? Explain with an example.
What are the advantages of parameterization ?
What do you to script when objects are removed from application?