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

What r the different filters in defect in quality center

3515


Will there be any standards or requirements for page appearance and/or graphics throughout a site or parts of a site?

800


How to use reporter.report event in qtp ?

782


What is the basic concept of qtp?

764


Which advantages helping QTP to hold the position of "Market Leader" for such a long period?

1593


how to post xml data from QTP scripts to any application?

1742


How to replay a script in qtp?

832


How can you close the second opened browser?

1072


What is the syntax to call one action in another?

768


What are the ways you can synchronize?

775


what is Property......End Property loop? how to write sript for it in QTP

2126


How to handle the exceptions using the recovery scenario manager in qtp?

781


how to create flat file datasubmission in qtp

2200


i have two questions for regular expression :- Q1. I have date pattern eg-29/11/2011 29-11-2011 29.11.2011 Que- if any separator is there between date,month and year pattern should match else it should not match eg- pattern should not match in case of 2911-2011 Q2. let say i have a string and there is a number in between of that string eg.-Amount 30002.234 successfully credited to your account . now i have to match this pattern in such a way that even if decimal is not there pattern should match ,how i will do this using regular expression

1227


What do you to script when objects are removed from application?

820