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
Why is Client side image is preferred over server side image?
what the difference between shared repository and per action repository?
How can you identify the browser and its information using the qtp script?
how to write xml output check point bu useing descriptive programing .means without useing output check point
how can you do retesting (datadriven test) using notepad amd by using functions NOTE u should not use datatable methods
what is the difference between the modular framework and datadriven frame work
How can you send user defined messages to test report?
What is an expert view and keyword view?
What is different command used in command Prompt while using QTP?
what is output value in QTP and how it can be used in automation testing
Explain the types of object repository?
Hi friends I need to know about jubula automation tool. Is anybody know in bangalore where jubula tanning class is going on do let me know. Its urgent for me to learn that tool please help.
What are the major/ important methods, functions in QTP we use realtime testing
How to use Environment parameterization? Explain with an example.
what are the mandatory properties for a tex boxc (scenario?)