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

How will you check that your test cases covered all the requirements?

559


Your roles and responsibilities and daily tasks? (As automation tester)

2576


What is Distributed testing? How does UFT support it?

604


What are the recording modes in wave event?

1532


Can I change properties of a test object?

618






what is command for executing files?

1510


in my application,validation message has in japanise language.how to validate this message is appears properly or not

1516


you are recording on "WINDOW 1", say it has a link if you click on that, that leads you to "WINDOW 2". If you do any manipulations on "WINDOW 2" that are automatically updated in to "WINDOW 1". But "WINDOW 1" is currently invisible. But the updations in "WINDOW 1" must also be recorded as a script in QTP. The best Example is if you update your resume in JOB STREET portal it actually happens in other window, but the previous window is automatically updated. Now does QTP help you in this types of situations? Any body can answer this question. please..... Siva

1490


How to customize qtp?

607


hi, can u tell me the QTP TEsting process in present real time companies?(beware of this... now a days Recording is not using,, only DP) and don't tell note book answers like step 1 spep2....like this .......post answer with professional skills in simple english words) thank u

1321


Hi all Can u give me the link where we can download full version of qtp my mail id is karthic.venkitapathi@gmail.com

1345


Have you used xml check point in your project?

550


How many ways we can parameterize data in quicktest professional?

553


Explain the difference between check point and output value?

490


how did u use automating testing tools in ur job?

1480