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

DataTable.Addsheet("Destination")
DataTable.ImportSheet "c:\path.xls","source","destination"
row=datatable.getsheet("Destination).getrowcount
for i=1 to row
datatable.SetCurrentRow(i)
val=datatable.Value("path","Global")
msgbox(val)
Next

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define virtual object?

611


What do you mean by checkpoints in qtp?

563


what is error and fault in terms of software quality?

1509


we use a file extension .properties why is it used and where do we use it plz help me out with detailed explanation and navigation of how to use on the QTP 8.2?

1634


Can any one send me the QTP Basic Coding Samples?

1614






How many types of recording facility are available in quicktest professional?

566


in data driven testing for performing operations which method is easy from manual test data,keyword view,or from database.and why?

1359


What is keyword driven framework?

622


Mention what are the different types of recording modes in qtp? Which will be used when?

564


What is difference between shared and local object repository?

589


Explain quicktest professional (qtp) testing process?

539


How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s.

535


How to use checkpoints in qtp ?

588


An object is non standard object, i mapped it to standard object, eventhogh on mapping to standard object i cannot use the methods available on the standard object with the mapped object. How i can use those standard object methods with these mapped object. (((Note : dont tell that we can use virtual object as virtual object is to map nonstandard obj to standard obj)))

1591


How to handle the exceptions using recovery secnario manager in quicktest professional (qtp)?

634