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
- 48090 Views
- IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / chivukula.kumar
datatable.Import("E:\Programming Samples\QTP
Samples\OrderNumbers.xls")
colcount = datatable.GetSheet(k).GetParametercount
rowcount = datatable.GetSheet(K).GetParametercount
shtcount = datatable.Getsheetcount
for i = 1 to rowcount step 1
for j = 1 to colcount step 1
for k = 1 to shtcount step 1
datatable.setcurrentrow(i)
val =datatable.Getsheet(k).GetParameter(j).ValuebyRow(i)
next
next
next
Note : the above script for entire workbook values we can
get .
next
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the pros and cons between QTP and Rational Robot
What is QTP scenario.
1. What is the difference between Keyword and function in the keyword driven framework? 2. How do you associate Keywords to the script ?
hi guys we r working in office...we write some scripts..suddenly we have a work(5min only) in out side..what will do now,,,used to system shut down or log off or lock or sleep mode,switch use or hibernate?
Define Error Pane of UFT?
What is the limitation to XML Checkpoints?
How can you pass value one action to another action?
Why do we use breakpoints in QTP?
How many ways is to parameterize the value?
What are the Test design techniques you uses in ur project?
How to data driven test for Win objects in QTP ?
Explain types of output values?
What are the features and benefits of quick test pro (qtp 8.0)?
What is recovery scenario manager? When you go for recovery scenario manager?
What is the difference between QTP and WinRunner? Why do you choose only QTP for automation among remaing tools like Rational robot and silk test? Write the VBscript for any functionality in your project ? What is the cost of QTP ? If you entered into yahoo mail with your valid user name then you will get FOR EXAMPLE , " welcome to krishna " on the top of inbo page , how can you test it in QTP? What type of testing you can do, when we gave you 5 screens and how can you test that application? What type of framework you are using in your company and explain it?
