How can we import a Open Office excel file in QTP

Question Posted / gvnsuresh

4 Answers
9701 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we import a Open Office excel file in QTP..

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

How can we import a Open Office excel file in QTP..

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

How can we import a Open Office excel file in QTP..

Answer / lakshman

we have cammend fot these

Datatable.import"path of the excelfile"

Is This Answer Correct ?

1 Yes

5 No

How can we import a Open Office excel file in QTP..

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

Post New Answer