Sign Up Login


  1. Categories >> Software >> Testing >> Automation Testing >> QTP
  2. Suggest New Category

How can we import a Open Office excel file in QTP

Question Posted / gvnsuresh

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

More QTP Interview Questions

Is QTP supports Unix. If yes, then how the test automation is done?

0 Answers   iFlex,

Hi,All How to create a link in excel sheet using qtp

0 Answers  

I have a Webtable object in my shared object repository, say WT1, which has different index value in 2 different versions, one version having WT1's index value as 1 and other version having WT1's index value as 2. how could i use same test script to identify the WT1 object having different index values.

5 Answers  

Hai anyone please "Explain about Framework in QTP?"

6 Answers  

Explain in brief about the quicktest professional automation object model?

0 Answers  

i need qtp tutorial. pls send it to sridhar.k151@g mail.com

0 Answers  

How can we add regular expression for date field (dd/mon/yyyy)?

3 Answers   CTS,

How to write script to display a message box having the "Date" value of the fourth mail(yahoo account). I've tried it with the web table concept but the content doesn't get displayed? Please help me out to resolve this :-)

2 Answers  

what is the difference between modular framework & datadriven framework

0 Answers   SDS,

can any body help me out by providing links/material for descriptive programming in QTP otherwise can you post decriptive programing based interview Questetion&ans. plz help me out . i need it.

1 Answers   ADP,

what is Compile Module in QTP? what exactly it contains Functions or Actions?

1 Answers  

What are the main features we have to compulsory test by using qtp in an web based application

1 Answers  

For more QTP Interview Questions Click Here
Categories