Answer / rico

datatable.importsheet --Import a particular sheet of the
workbook whereas datatable.import--> imports the total
workbook sheets

DataTable.ImportSheet(FileName, SheetSource, SheetDest)

DataTable.Import ("C:\flights.xls")

Answer / bfakruddin

Datatable.importsheet:

It imports particular sheet from our desired excel file, we
can use the data available/our desired data from particular
sheet in any excel file.

Datatable.importsheet "path of the .xls file",srcsht,destsht

Datatable.import:

It imports all the data in excel file, all the data from all
the sheets with their names to our datatable in QTP

Datatable.import "path of the file"

"Can anybody tell what are the drawbacks of both?"

Hi, I am supposed to automate mainframe application through qtp. I do not know how to start abt it. Can you plz help me in first initializing the process or do you anybody have a guide book or a link which guides me through the process of automating the mainframe applications and things involved in it.

0 Answers  

---

How to handle the errors without using recovery scenery?

3 Answers  

---

how to call multiple scripts in QTP at a time

3 Answers   IBM,

---

write progamming connecting QTP to database sql? this is question asked by interview? please give sql, pl/sql related answer?pls any answer this?

3 Answers   IBM,

---

What is test object model in QTP ?

8 Answers  

---

---

what is the advantages and disadvantages of using functions instead of re usable actions

0 Answers  

---

Explain how you can delete excel file in qtp?

0 Answers  

---

what is qtp automation frame work,what is the use of that frame work?

64 Answers   Cap Gemini, IBM, iGate, TCS,

---

Please Clarify if smartidentfication is used at runtime when qtp does not recogonize the objects

3 Answers   Ordain Solutions,

---

How can i click on any Excel sheet's "H" column with out writing coordinates Ex:Window("Book1").WinObject("Book1").Click 498,14 I dont want to give coordinates like 498,14 Can i open "H" column by writing like Ex:Window("Book1").WinObject("Book1").Click "H" or Ex:Window("Book1").WinObject("Book1").Click "H","1" or Ex:Window("Book1").WinObject("Book1").Click H,1 If i want to click on "Sheet3" of an excel sheet, Can i open like Ex:Window("Book1").WinObject("Book1").Click "Sheet3" Please help me any one

0 Answers   Livetek,

---

What are the five challenges you faced in QTP?

0 Answers   CTS,

---

Can any one brief some detail on how the shared and action object repository utilized/implemented in a real time project. I already know how to make shared object repositor by saving OR as .tsr extension..I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thanks

0 Answers  

---