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 / sridatta

Dim i,row
row=datatable.getsheet("YOURSHEET").GetRowCount
for i=1 to row
datatable.getsheet("YOURSHEET").SetCurrentRow(i)
<---Do your Operation-->
This code will word

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

• What type of testing questions will be asked for 2+ yrs exp people in interview?

1252


i'm testing the webpage with QTP, in this wabpage i have to choose the CV from the window, but QTP can't recognize the object, so i used the Low LEvel Recording, but every time i run the test, QTP go to halt when it gets to the Recorded part, any solution for that?( except puting delay in the script and manuall selecting, because i've did that)

1550


What is smart identification in QTP?

621


what frame work you are following?

1520


This is Karthic and my mail id is karthic.venkitapathi@gmail.com, please give me an idea to crack qtp 10

1501






can any boby tell me what is method or steps to connect the remote desk top by using QTP 9.2 version?

1615


How will you find the current time of the remote machine using QTP script?

591


How to use setroproperty?

567


How will you declare a variable in qtp?

548


What are the methods of the TextStream object that are used for reading from a text file?

1687


What are the technologies supported by qtp?

556


Can any body please tell me the steps of keyword driven frame work in qtp. My mail is saswat445@gmail.com please send some materials on keyword driven testing in qtp. thanks a lot...

1786


when to start the automation?

1473


how did u use automating testing tools in ur job?

1480


hi in real time who will execute the qtp test scripts? my faculty said, in a companty automation testers are written the test scripts and manual testers are execute the test scripts...IS IT RIGHT OR NOT?

2785