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

What is Virtual Object? Plz Explain me with an example?

2 Answers   Ordain Solutions,

---

Explain script generated at the time of setting runtime property?

1 Answers  

---

write a function to read the items from Combobox of Flight Reservation application and save in excel.

5 Answers  

---

how can i change the action path that called in other action. when i copy one action to other pc,the action"test2" calls another action(C:\test1\action0),and i update this"test1",the folder update to "action1",but when i open "test2", it just point the call path to "C:\test1 \action0", but does not update to "action1",and the change i make can be shown in test2. so, can i update the call path manully? thanks

2 Answers   HP,

---

what is the purpose of QTP?

2 Answers  

---

Can anyone tell me what is the equivalant method to be used in QTP for "web_obj_get_text" used in winrunner. My winrunner code is below. set_window("Confirm Add Subscriber"); rc = web_obj_get_text("Add subscriber:","#8","#1",orderID,"The order number is","\.",1); basically I need to retrieved the "orderID " from a string present in 8th row & 1st col of table "Add subscriber"

1 Answers  

---

whenever a scenario is recorded ever, it creates a object repository automatically (‘per action’ /local ). we do not need to make them individually…then why we need a shared object repository. How it will be practically utilized ?? your input will be highly appreciated..

5 Answers  

---

we use a file extension .properties why is it used and where do we use it plz help me out with detailed explanation and navigation of how to use on the QTP 8.2?

0 Answers  

---

How to get the column count and column name from the resultset in the database connection program?

5 Answers   TCS,

---

Can any one tell me about "Mapping Repository Parameter Values" and why we use it....??How to use it???Please, tell the preconditions also...........???? Thanks in Advance

0 Answers  

---

When do go for loop condition in test?

0 Answers  

---

anyone can explain about "Smart Identification" in QTP I mean what is the use of "Smart Identification" Give an example

2 Answers  

---