How to export data in excelsheet to qtp without using
datatable.

Answer Posted / rajesh

Set objInputDataxlsFile=createobject("Excel.Application")
objInputDataxlsFile.workbooks.open <File_name_Path>,true,true
Set
currentworksheet=objInputDataxlsFile.Activeworkbook.Worksheets(1)
UserID = currentworksheet.cells(1,3).value
Password1=currentworksheet.cells(2,3).value
Status = fnLogin 'Call to login function
currentworksheet.cells(4,3).value= Status

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is checkpoints for qtp?

629


What is post recovery scenario?

1749


What is the short cut keys for the following?

710


What are the types of properties that quick test learns while recording?

629


How can you give wait up to 10 seconds in qtp?

684






What is the quicktest professional (qtp) testing process?

655


What is quicktest professional (qtp)?

652


Approach for Installation,comaptibility,system testing

1804


I am sathish , i want to test the Application of JIL.org ,Mobile Emulator ,by using QTP10.0. I am trying to do testing on that Application , but Child Objects are not identified by the QTP. Please can any one help me

1524


What is the latest version of qtp?

681


In the application that I'm testing is having a WYSIWIYG editor.QTP is recording editor's body as web element. I want to add some data to this web Element at run time. The problem is that I cant find a method to add contents to this web Element. Can any one come up with an answer for this. Thankx.

1538


What is Distributed testing? How does UFT support it?

685


What is data driver in qtp?

659


What is the significance of “action 0” in qtp?

660


In qtp, explain what is qrs file?

694