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 |
What are Error handling other than Recovery scenario manager?
hi, for QTP TRAINING......SURESH REDDY SMART SOLUTIONS sr.nagar IS BEST OR NOT? how faculty teaches?
Output values? i want a practical example
descriptive program for a yahoo mail that is in yahoo mail suppose check box mailid subject assume it is like this format all things are in webtable the question is suppose some mail ids are there in that mailids i want to select the check box wich is before a@gmail.com and after that i want to click on delete button
How to open a new test using quicktest professional?
How to handle the exceptions using recovery secnario manager in quicktest professional?
hi what is the use of "dim" in automation objective model or any where what is the use of "dim" plz tell me
How do we analyze the checkpoint results?
what are recovery management techiniques?
2 Answers BirlaSoft, GL Noble Denton,
Write a QTP script to enter a keyword in to Google search engine?
How to Compare the 2 xl-sheets in QTP? ple write the vb Script for the comparison?
w is fragmentation and paging