Interested to Buy Any Domain ? << Click Here >> for more details...
How to export data in excelsheet to qtp without using
datatable.
- 4 Answers
- 12917 Views
- I also Faced
- E-Mail Answers
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
Hi can anybody send me the QTP material, To my email ID: nuve1284@gmail.com ?
Can any suggest me what is exposure testing?
How the smart identification is used in real time?Please explain with an example
What are the differences between qtp and winrunner?
what is the diffrence bw qtp architectute and qtp framework?
What are the features supported by UFT?
Hi, I am using 2 excel sheet.First excel sheet works fine with the script, if it opens the 2nd excel sheet,it works fine,but after finish all the rows it is giving the following error in the following line. InValid Procedure call or argument Line (178): "Browser("name:="&result,"application version:=internet explorer 7").Page ("title:=bgt.*", "index:=0").WebList ("name:=SearchType","html id:=Select1","location:=0").Select SearchType1". I have seen a web article says that,If we use any vbscript friendly name it may gives the above error-Invalid procedure call or argument not sure,Am I using any VBScript frienlyName? in the above line? [but the same line is perfecly working for first Excel ] It is little urgent. Any Help Thanks you
Explain how you can replace string in qtp?
Define Canvas view of UFT?
how do we know whether all objects are stored in the object repository or not? how can we know if a particular object is not stored in the repository?
please any one can explain the keyword driven framework. with gmail example.
In qtp, how you can get the last character from a string?
Explain in brief about the quicktest professional (qtp) automation object model?
Is there anyway to automatically update the Datasource name in Database Checkpoints object when we migrate tests to a new release?
On the website, the protocol has been changed https: to https what you will do? Tell me your approach?
