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
What is checkpoints for qtp?
What is post recovery scenario?
What is the short cut keys for the following?
What are the types of properties that quick test learns while recording?
How can you give wait up to 10 seconds in qtp?
What is the quicktest professional (qtp) testing process?
What is quicktest professional (qtp)?
Approach for Installation,comaptibility,system testing
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
What is the latest version of qtp?
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.
What is Distributed testing? How does UFT support it?
What is data driver in qtp?
What is the significance of “action 0” in qtp?
In qtp, explain what is qrs file?