How to get data from excel sheet to the script? write the
script.

Answer Posted / srinath

close the excel sheet which you want to open in QTP
first row will always be column name which will be used in
script

datatable.import("c:\path,,,\xlsheetname.xls")
a=datatable.value("jksdfj")

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When should I use smart identification?

604


How many types of recording modes in qtp?

587


How can i initiate the objects to find uniquely in OR

1470


what is meant by source control?

1695


If the objects hierarchy is changing from build to build, then how you will handle that condition?

619






we add library file used in test via settings or through "ExecuteFile" command. when we implement framework do we make common library file and load the same for all the test cases execution?

1581


Dear All , For UFT 12.02 which version QC or ALM will support ? Thanks Balaji

921


If an application name changes frequently i.e while recording it has the name, in this case, how do qtp handles?

583


Print the Prime numbers in below format only up to 20(Need commas also) 1,2,3,5,7,9,11,13,17,19

1184


How may types of defects identify application or your currently working application?pls give me answer..

1515


How can I change object description or check point values in qtp?

555


How many types of actions are there in quicktest professional (qtp)?

536


How do you configure QTP AND Test director?

1496


Describe how Smart Identification is used

1697


How do we handle run-time errors?

581