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
Why is Client side image is preferred over server side image?
What is the virtual object?
Print the Prime numbers in below format only up to 20(Need commas also) 1,2,3,5,7,9,11,13,17,19
What is QTP scenario.
Hi, can explain the draw back of manual testing.plz send me the answer to my mail id deepthip1985@gmail.com
Where we use data driver in qtp?
Can we record using all the modes in a single script? Explanation with example is appreciated
Is it possible to use two instances of UFT on the same machine? If not why?
How do client side image and server side image work?
Hi.. I want to do parametrization for selecting perticular flighr say XYZ by using local table: criteria: 1.If flight is available msgbox "Flight is available" and then select flight from flight table and click to ok button after that as enter username and ticket no and then stop 2. otherwise msgbox " Flight is not available" and stop Please help me out ..and let me know your responses on dipak.bachhav@gmail.com Regard, Dipak
If created one virtual object? Next time I changed the window position will it work?
What is the quicktest professional testing process?
regular expression in qtp standar check point for months from accepting months from january to december only
Explain different types of checkpoints?
How to attach a file to TD?