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 review
Explain the features and benefits of quick test pro(qtp)?
hi in real time who will execute the qtp test scripts? my faculty said, in a companty automation testers are written the test scripts and manual testers are execute the test scripts...IS IT RIGHT OR NOT?
How can you close the second opened browser?
What are the different types of functions available in qtp and explain ?
What is the extension of qtp local repository?
How many test scenarios you have automated? How many time it will take to execute 30-40 scenarios? What SDLC model you are following? How often you will execute your test scripts? Because of some changes, your test scripts failed? When you will update your test scripts? How much time it will take to update? Do you know how to connect database? Do you know the direct method to count no. of records (or) rows present in record set once query is executed? How will you create the connection string? How did you resolve conflicts present in Object Repository? How good you are in VB? How will you work on Excel Application? How will you select Excel sheet? If you want to select 10 sheets, will you create 10 separate objects? Given string is “abcd”. What are the methods you will use to display “dcba”? Drives script – explain the frameworks? How you are updating results for each test? What is start up, configuration, navigation scripts? If you are not able to understand the application (some module), who will teach you? What test cases to be automated? When to be automated? What is the testing process you are following? What life cycle you are following? When you will use Descriptive Programming? Do you have the permission to add objects into shared object repository? (OR) someone will maintain SOR? Do you know how to add objects into shared object repository? How many test cases you have automated? How much time will it take to execute? What is complex in automation? When you feel automation is complex? Tell me one scenario, the complex functionality you have automated in your project? Excel sheet having some datas and some datas present in the application (in table). How will you compare these two datas? Write code to fetch datas from Excel sheet. Rate yourself in SQL? Display the employee name who is getting maximum salary? sal ID Salary name 001 100 002 500 003 300 ID 001 002 003 Ename A B C Have you written any test cases while you are in Automation? Manual Testing also will you do or you will work only in automation?
what is meant by function library?Public and private functions in function library? if private functions are applicable for only for the particular test means then y we have to add those to function library?
Explain the new feature of UFT regarding the export of test results?
What is the differences between image check point and bit map check point?
What is a reusable action?
What is CMMP and CMMH?
How to save your test using quicktest professional (qtp)?
What is meant by Step generator?what is the use of this? we have 3 steps know there what r all those.? can u all pls give me clear idea of this
How software tester can use constants and variables in scripts?