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 are the types of environment variables in qtp?
how to fetch the values from grid? & qtp recogniges that grid as a webelement? what u do?
what is the frame work in J-meter?
Difference between copy to action and call to action?
Create flight reservation login descriptive programing (Condition: Remove the value and substitute with a variable, and then call the validation from Excel) Plz help me....... very urgent.........
Explain the checkpoint in qtp?
What is the difference between Keyword Driven test and Data Driven test?
I am in .Net development for past 3.5 years and want to enter in to automated testing and learn QTP. For this I need some good tutorial for beginners. I will be really greatful if any one has and they can send it to me on this address- ruchidureja@gmail.com
Can QTP be used for GUI testing ?, We are using Java with MySQL and Operating system is Linux. We are NOT using the web.
How qtp recognizes the object?
When you open QTP, how many sheets you can see?
how can we compare descriptive programing with a regular expression
What is output value? How many types of output values are there in qtp?
How to capture a window in QTP?
What are the types of properties that quick test learns while recording?