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
- 45076 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
how can i pass a "automation script" as a parameter in a function give me need full suggestion thank inadvance
How to add synchronisation points in qtp?
What is the difference in the global and action sheet in qtp?
To retrive the test data which tool vl use and whats basis u vl write test data? its urgent
What is object spy in quicktest professional (qtp)?
what is actually contain test report? can anybody post the test report
What is qtpro? What is quick test pro? What is a quick test professional?
How many test scenarios you have automated? How many time it will take to execute 30-40 scenarios? What SDLC model you are following? How often you will execute your test scripts? Because of some changes, your test scripts failed? When you will update your test scripts? How much time it will take to update? Do you know how to connect database? Do you know the direct method to count no. of records (or) rows present in record set once query is executed? How will you create the connection string? How did you resolve conflicts present in Object Repository? How good you are in VB? How will you work on Excel Application? How will you select Excel sheet? If you want to select 10 sheets, will you create 10 separate objects? Given string is “abcd”. What are the methods you will use to display “dcba”? Drives script – explain the frameworks? How you are updating results for each test? What is start up, configuration, navigation scripts? If you are not able to understand the application (some module), who will teach you? What test cases to be automated? When to be automated? What is the testing process you are following? What life cycle you are following? When you will use Descriptive Programming? Do you have the permission to add objects into shared object repository? (OR) someone will maintain SOR? Do you know how to add objects into shared object repository? How many test cases you have automated? How much time will it take to execute? What is complex in automation? When you feel automation is complex? Tell me one scenario, the complex functionality you have automated in your project? Excel sheet having some datas and some datas present in the application (in table). How will you compare these two datas? Write code to fetch datas from Excel sheet. Rate yourself in SQL? Display the employee name who is getting maximum salary? sal ID Salary name 001 100 002 500 003 300 ID 001 002 003 Ename A B C Have you written any test cases while you are in Automation? Manual Testing also will you do or you will work only in automation?
What is text check point and text area check point?
what type of run time errors you get while you ar edoing rpg program?
How is UFT 11.5 version different from UFT 12.0?
What are the different recording modes?
How to explain a banking project in interview as a test engineer???
What do you to script when objects are removed from application?
Which environments does qtp support?
