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?"

In automation testing, while doing descriptive programing; how will u get the properties of the objects in what format, what type of a document, and by whom? Pls explain in detail. Thanks a lot

2 Answers   Quest,

---

In a Web appl, on a page, there are student names & details listed.On clicking sort button,details are sorted on Names.How do u verify htat sorting is done by using QTP?

1 Answers   IBM,

---

In a webtable,a list of values are there,rightnow one values shows,later random another values shows,but how to retrieve the random value in webtable.

1 Answers   HP,

---

how to select particular value from the combobox in the current page which is entred in the previous page editbox after parameterization?

5 Answers   Ordain Solutions,

---

What is the difference between action & script?

3 Answers  

---

I have two For loop, first For loop does is creates a customer and input the customer info and then the second for loop within the first for loop does the follows which is capture the customer name and verify the with the data within the datatable. The problem I am coming across is that when it goes through the second time creating another customer and then verify the second customer then it creates the following during runtime. I want is to have the customer2 below Customer1 under the Customer_from_Apps. Any help will be greatly appreciate it. Customer Customer_from_Apps Customer_from_Apps1 Customer1 Customer 1 Customer2 Customer2 Window("Customer Desktop").Window("Customer Tracking (Privacy").WinObject("TreeView20WndClass").Click 92,244 runtimevalue = .VbTreeView("vbname:=AppServerTree").GetROProperty("Selectio n") Customer_Val= Datatable.GlobalSheet.AddParameter ("Customer_from_Apps",runtimevalue) row=datatable.getsheet("Global").GetRowCount For x=1 to row datatable.SetCurrentRow(x) Data_Val=Datatable.Value("Customer",dtGlobalSheet) If (trim(Customer_Val)=trim(Data_Val)) Then Reporter.ReportEvent micPass, "Customer validation successful", "Actual Value: " &Data_Val&vbcrlf& "Customer Value: " &Customer_Val else Reporter.ReportEvent micFail, "Cusotmer validation unsuccessful", "Actual Value: " &Data_Val&vbcrlf& "Customer Value: " &Customer_Val End If Next

0 Answers  

---

how to do spell check in QTP? reply please

8 Answers  

---

What are the different types of recording modes in qtp? Which will be used when?

0 Answers  

---

HOw to add the recovery file at runtime to the test file .

0 Answers  

---

What is test object?

0 Answers  

---

What is diff between SDLC AND STLC?

1 Answers   Nokia,

---

What are the automation metrice in your project?

0 Answers   Accenture,

---