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

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.

Answer / lakshman

we have cammend fot these

Datatable.import"path of the excelfile"

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

Explain about import and export files?

1 Answers  

---

How to enable the text check point in qtp? By default it is disables

1 Answers   Sify, ssinformatics,

---

what is the purpose of SetTOProperty Method?

1 Answers   Cap Gemini, iGate, Wipro,

---

I want to know how to execute the descriptive programming in qtp for the webedit object which does not contain attached text property. but i have checked it with name and html id property. Even though it is not executing. it is giving error in object's physical description.

2 Answers  

---

How to identify whether a web page exists or not without using Browser(" ").Page(" ").Exist?

1 Answers  

---

what is difference between normal mode and fast mode?

1 Answers  

---

How to execute a VBS file without using Execute File statement?

3 Answers   iGate,

---

Explain the terms test and business component?

0 Answers  

---

what is diff b/w function and action?

8 Answers   VSoft,

---

when there is a task that gets repeated in multiple scripts what do you do in QTP?

2 Answers   Ordain Solutions,

---

What are the environment variables?

3 Answers  

---

somebody please say me why we go for using regular expressions,actions.what is the main and exact use of this in real time applications.real time testers pls answer my question with example if u can

4 Answers  

---