how do u import the test cases written in excel sheet to
qtp? and how do u generate the script in qtp for the
testcase in excel sheet? plzzzz do answer this question
thanks in advance

Answer Posted / sunita

1.goto QTP
2.datatable.Addsheet "xyz"
3.datatable.import"C:\a.xls",1,3
1 is source sheet of a.xls
3 is destination sheet of xyz
a=datatable.getsheet(3)

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain runtime dynamic settings?

2144


I want to test my vb.net solution file using qtp. Does Qtp test only .exe file?

1854


How extensive or customized are the server logging and reporting requirements; are they considered an integral part of the system and do they require testing?

698


why should we give deliver good quality software?

1761


explain how to write vb script in qtp?when will you write own script?

1986






Discuss the QTP Environment?

748


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

2704


Dis advantages of XML checkpoint ?

1695


I AM TRYING PORT CODE FROM WINRUNNER TO QTP AND DON'T KNOW TO HOW TO CHECK THE ERRORS. IN WINRUNNER FUNCTION RETURNS EIGHER 0 OR -1 AGAINST WHICH RESULT CAN BE MADE PASS OR FAIL BUT IN QTP I DON'T SEE FUNCTIONS RETURNING ANY VALUE. APPRECIATE IF ANYONE COULD HELP ME CONVERTING FOLLWOING WINRUNNER CODE TO QTP. set_window("Customer Service"); rc = web_obj_get_text("Summary","#2","#4",ssn,""," ",1); if (rc != E_OK) { report_msg("[GetSubscriberSummary] Could Not get subscriber SSN; rc = "&rc); myRC = rc; } else { ssn = StripBlank(ssn); if (DEBUG) report_msg ("[GetSubscriberSummary] SSN: "&ssn); }

1891


What is expert view in qtp?

723


If created one virtual object? Next time I changed the window position will it work?

722


i'm using the qtp to test to vb appliction,i wanted to get the new application's title.i didn't want to use the winAPI to get it ,i 'd like to know whether a QTP function can do it. Eg: SystemUtil.Run "C:\Program Files\.....","","","" 'run an application, and misure the application is activating,then how to get the hwn wihtout using windowns api

1614


Define Canvas view of UFT?

734


How software automation specialist enter steps in the Expert View?

1789


Explain the concept of object repository and how qtp recognises objects?

653