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
- 45093 Views
- IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / jay desai
When you are importing an excel sheet into QTP, the
datatable defaults to the first row. Below is an example
that will help you importing all the data into QTP.
Dim jj,Rows
Rows=DataTable.LocalSheet.GetRowCount
For jj=1 to Rows
DataTable.LocalSheet.SetCurrentRow(jj)
.......
<Perform your operation>
.......
Next
'I hope the above code will work.
| Is This Answer Correct ? | 7 Yes | 9 No |
Post New Answer View All Answers
What are the key points to create a framework in QTP for oracle forms?
How to start recording using quicktest professional (qtp)?
How to carry out bit map check points in QTP
How you calling actions in qtp?
What is the use of Debug Viewer?
how to test use the quality control .how to verify the image verification
What is file database?
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
If object is not recognized by qtp but the object is standard object what is your approach?
What is an expert view and keyword view?
Generic function to search for the unique link in webtable and click on it
how to use the regular expression for the below code-- swf("application name").swftreeview ("Treename").select"Medication;Pharmacy:56" There is a tree view window of the folder's ie Medication- >Pharmacy(sub folder)with 56 as count of records...The records can be different or if no records present in the specific folder..then it show "Paharmacy:-no records".Whe i record at the first time .....and try to rerun the same script with different records count say "pharmacy:800"..qtp is not regnizing it...therefore i want to user regular expression..but donot now how to use it and where to use...i have tried.... swf("application name").swftreeview ("Treename").select"Medication;Pharmacy:\*"..but it s of no use..plz help..me
Hi we are running tests remotely from quality center and pushing tests into qtp boxes remotely, and it does execution but while uploading results back into quality center it hangs in qtp box.If any one come across similar problem, please send me details how to handle this. Thanks kris
How would you export a script from one pc to another in qtp?
Suppose you are using shared objects repository in your test and you want to split your present action? At that time shared object repository is single or it’s also splits?
