How can we import a Open Office excel file in QTP
Answers were Sorted based on User's Feedback
Answer / ganesh raj
Set excelObj = getObject(, "excel.Application")
Set openExcelWB = excelObj.ActiveWorkbook()
exPath = openExcelWB.path
openExcelWB.close
excelObj.quit
excelObj = nothing
Data table.Import exPath
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / udham singh
u cannot work on any excel sheet in QTP if it is already opened.first u should close the excel sheet then only u can import it 2 QTP and can perform other operations by QTP.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / lakshman
we have cammend fot these
Datatable.import"path of the excelfile"
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / prem
1)Activate the menu item view-->select the option datatable
2)right click on datatable file-->import from file click ok
3)select the desired excel file from location
4)click on open
| Is This Answer Correct ? | 2 Yes | 9 No |
how did u use automating testing tools in ur job?
How do you convert manual test cases to automated test cases?
Now it appears to be more than enough... I have learn entire QTP, I did whatever I could do but still facing lots of problem and those problems could be removed only after working in professional atmosphere. But still unable to expose myself as professionaly. It is becoming panic, It has been two years I am in manual testing and looking for the change but all the recruiters ask for QTP, but my problem is I don't have working experience with QTP. Kindly suggest me I really need effective suggestions. I dont have more caliber to work with present organization cause of salary reasons...boo.. hooo...hooo. My email address is alkaa.dugaal@gmail.com
what is check point?
did you perform retesting(DATA DRIVEN test) using functions with out using datatable methods how can you perform retesting using functions
What is Cross browser testing? Does UFT support it?
how we can take data in the username field text box into variable in web application explain with example and give all functions to get data into variables
give me the code for check point for validating application
How smart identification works in qtp ?
With help of object repository,we can able to write the descriptive program manually?
What is the default add-ins in qtp?
What does "Dynamic change on web pages" means.As per my knowledge, this comes in "Complete" level of Active screen capture levels, where it says, "Also dynamic changes on web changes are saved.so i want to know what type of dynamic changes are made and is this dyanmic changes efftes only on web application or any other?