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
- 47962 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
I am having major problems with some DB Table Checkpoints I add to my script. I 35 web based applications recorded and each has DB Table Checkpoints insert but only 1 script isn't recognizing the DB Table Checkpoints for some reason. I've checked the DB connections and the info in the Library Functions and still only this one script out of 35 doesn't recognize the DB Table Checkpoints. Can someone please help me figure out why only this one script out of 35 that's hitting the same database is having a problem.
Is virtual object supported in low level recording mode?
Have you used xml check point in your project? How?
What is Port testing. Whhen will you perform?
What is the syntax to call one script from another?
Explain the qtp test phases.
What is the virtual object?
hai, i completed my b.tech in 2010 with 62.3%. i having knowledge on manual testing and Qtp. i want Relavent experience in testing.watever may be d salary i dont bother..I just want to gain knowledge. i dont have good communication skills.
For example you are checking bit map check point before coming to the results. How can you say it is passed? Or failed? Anyways?
How QA specialist can identify when programmatic descriptions are useful?
Why do you create a text checkpoint on a Web application? What is the purpose of the Close method?
What are the ordinal identifiers in web page?
Can any one say what exact diff between test->parameters, action properties-> parameters. after defining the parameters in test->settings, how can we access those parameters.(i know how to use action prop parameters)
How QTP identify the system time that's changes every seconds?
Hi, I am working on microsoft infopath forms..It is standalone form..(not dotnet or web.) . I am not able to indentify any objects in it.. I am currently using active accessibility in the macro for the same but its execution is too slow.. Kindly help in case you have better solution.
