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 is the new version of qtp which is recently released in the market?

856


How qtp recognizes the object?

884


what is the latest version of QTP? Main difference between 9.2 and 10 version

1787


What is recovery scenario manager? When you go for recovery scenario manager?

821


what type of framework u r using in ur organization

1856


What is test object model in quicktest professional (qtp)?

773


How do you do batch testing in wr and is it possible to do in qtp, if so explain?

709


What is QTP and the use of QTP in TD?

816


How do Parameterization and Data-Driving relate to each other in QTP?

834


what is error and fault in terms of software quality?

1688


Explain the concept of object repository and how quicktest professional recognises objects?

783


I want to do QTP Certification what is the pattern of Question paper.

1965


A FORM CONTAINS 5 FIELDS. 1 FIELD IS ENABLED REMAINING(4) FIELDS DISABLED. MY QUESTION IS ENTER VALUES INTO 1 FIELD AFTER THAT CLICK TAB BUTTON THEN 2 FIELD ENABLE THIS PROCESS CONTINUE UPTO 5TH FIELD. HOW TO WRITE CODE IN DESCRIPTIVE PROGRAMMING. PLZ TELL ME THE PROCEDURE AND CODE FOR IT.

1511


RECENTLY I PLACED IN QTP..HOW TO IMPROVE VB SCRIPTS KNOWLEDGE? IAM STRUGGING TO WRITE THE AUTOMATION SCRIPTS? ANY BODY TELL HOW TO IMPROVE QTP SCRIPT SKILLS?

2431


What is keyword driven framework?

865