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

Answer Posted / cheryl

datatable.import("xlsheetname.xls")

Is This Answer Correct ?    10 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of actions are there in quicktest professional?

514


Write a script to verify font style and color of a windows object using descriptive programming

837


what QTP Options do you know?

2926


Anybody plz give, How do you test aframe in a web page? If page cotain text message or Images, tables?

1560


How can i click on any Excel sheet's "H" column with out writing coordinates Ex:Window("Book1").WinObject("Book1").Click 498,14 I dont want to give coordinates like 498,14 Can i open "H" column by writing like Ex:Window("Book1").WinObject("Book1").Click "H" or Ex:Window("Book1").WinObject("Book1").Click "H","1" or Ex:Window("Book1").WinObject("Book1").Click H,1 If i want to click on "Sheet3" of an excel sheet, Can i open like Ex:Window("Book1").WinObject("Book1").Click "Sheet3" Please help me any one

1602






After executing the script in qtp suppose i found some script execute successfully and found some error.So how to report the status for both (i.e pass and fail report)in test director. For "fail" We use "defect tab" in testdirector. But for "pass" how to report it to TL.what is the process plz anybody ans

1677


WHAT IS THE DIFFERENCE BETWEEN QTP SCRIPT AND VB SCRIPT? HOW MUCH PERCENTAGE WE USE IN QTP SCRIPT REAL TIME AND HOW MUCH PERCEN OF VB SCRIPT,,,,,,,

1504


What are the flaws in water fall model and how to overcome it?

560


How is a Step generator used in UFT?

660


How to data driven test for Win objects in QTP ?

1475


How will you test a keyboard?

601


Get the count of files of similar types from a folder.

975


Hi.. I want to do parametrization for selecting perticular flighr say XYZ by using local table: criteria: 1.If flight is available msgbox "Flight is available" and then select flight from flight table and click to ok button after that as enter username and ticket no and then stop 2. otherwise msgbox " Flight is not available" and stop Please help me out ..and let me know your responses on dipak.bachhav@gmail.com Regard, Dipak

1631


How many ways we can parameterize data in quicktest professional?

561


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

639