why can't you use excel directly in qtp. why we want to
import excel data into Datatable.



why can't you use excel directly in qtp. why we want to import excel data into Datatable...

Answer / santosh

Working with excel in qtp involves creating objects and
opening sheet in a particular way. So, it has certain steps
to open and close a document creating more code. Instead
just import the xl using just one line of code. Do ops and
export it back.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More QTP Interview Questions

what is the abbrivation of .mtr in action reposirtory?

8 Answers   GE,


when we right click on the desktop of any operating system we find a menu , consisting of refresh,edit,open,paste and cut etc... how to load the object and object properties of that menu in QTP

3 Answers   iFlex,


str="QTP AUTOMATION TESTING" here how many T are there in the str finally i want to display the T

10 Answers   HCL,


1--How many functions u develop 2--What is an array 3-- where is ur server 4--U involved in unit testing 5--how ur test the background colour using QTP

0 Answers  


How to check feasibility of the appliction?in automation testing?

0 Answers   CTS,


QTP Query: Hello to all, I'm getting an error (as below) when I perform descriptive programming on any Web application. "The test run cannot continue due to an unrecoverable error.The "myvar_0" object was not found in the Object Repository. Check the Object Repository to confirm that the object exists or to find the correct name for the object " But I do not have any problem when I perform the same descriptive programming on a Windows application such as Sample Application - Flight. Previosly , I had prepared a lot of scripts - both via creating the properties collection object and by giving the description in string arguments and implemented them on Flight and they're working perfectly fine.I'm using QTP Version 9.2 The sample script I have used for Web application is as below : Set myvar_0 = Description.Create 'Setting property collection object for Browser myvar_0("class").value = "Browser" myvar_0("name").value= ".*" 'Setting property collection object for Page Set myvar_1 = Description.Create myvar_1("class").value = "Page" myvar_1("name").value= ".*" 'Setting property collection object for Text box Set myvar_2 = Description.Create myvar_2("class").value = "WebEdit" myvar_2("name").value= ".*" 'Setting property collection object for Button Set myvar_3 = Description.Create myvar_3("class").value = "WebButton" myvar_2("name").value= ".*" SystemUtil.Run "C:\Program Files\Internet Explorer\iexplore.exe" Browser("myvar_0").Page("myvar_1").WebEdit("myvar_2").Set ("hello how are you ?") Browser("myvar_0").Page("myvar_1").WebButton ("myvar_3").Click Browser("myvar_0").Page("myvar_1").Sync Browser("myvar_0").Close As our application is a Web based application, I was planning to make a few changes in regards to the object names, but unfortunately I am getting the above mentioned error. Could anyone please advice me, whether it could anything to do with the run setting or anything else.I am getting the same error even while implementing on our Sample Application - Mercury Tours website. I would be grateful to anybody who can solve my problem !!

1 Answers  


am not having intrest in coding lang like c c++ java etc can i choose Testing tools as my carrier and please suggest me which tool is good (suitable for me)

0 Answers  


can any one tell me How exactly data drivent testing is done in.explain with any example and the exact steps to fallow?

2 Answers  


How to see entire results at the same timeafter the batch run.. Cannot see the entire results at a time. Is there a easier way view everthing at same,as our batch file very large

2 Answers  


What is debugging? How you debug your script?

0 Answers  


What is parameterization? What is syncronization pt.?

3 Answers   Semantic Space, SRM,


Difference between image checkpoint and bitmap checkpoint

2 Answers  


Categories