What is diff betwee datatable.importsheet "path" and
datatable.import

Answers were Sorted based on User's Feedback



What is diff betwee datatable.importsheet "path" and datatable.import..

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

Is This Answer Correct ?    6 Yes 1 No

What is diff betwee datatable.importsheet "path" and datatable.import..

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More QTP Interview Questions

What is the default object synchronization timeout in qtp?

0 Answers  


Hello! i am having two comboboxes.Each having 10 items in it.when i select first item in first combobox,it is not similar in the second combobox.for ex in first combo if it is Hyderabad,in second it should be some chenai or some other item .Write a VBSCRIPT for that?

3 Answers   Tech Mahindra,


How to test the login page in different ways in automation testing and i need code?

0 Answers   Cognizant,


How do you done Data-Driven Testing using MS-Word. What is the script for that

3 Answers   IBM,


What does VBS file contain..? what is VBS file.?

4 Answers  






write script to read and write data from file ?

2 Answers   HealthAsyst,


Can we directly start working with QTP without any knowledge on WinRunner? (After getting trsining on QTP)

1 Answers  


I have 5 save buttons in my application on 5 different tabs one after the another . I have spy them and added each of them in my OR. My Or is able to highlight each button on each of the 5 tabs. But when I run the script it does not click the object.Is there anything I have to edit in OR. Any property to add or delete? Below are the properties of 5 save buttons. My code for each is like browser().page().savebutton1.click Browser().page.savebutton2.click Properties of 5 buttons Dhopare, Namita Sent: September 2, 2015 2:57 PM To: Vullengala, Jagadeeshchandra "Class Name:=WebButton", "abs_x:=718", "abs_y:=693", "class:=Button", "disabled:=0", "height:=22", "html id:=btnSaveTab1", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""btnSaveTab1"" class=""Button"" onclick=""document.getElementById('a1').click();"" name=""btnSaveTab1"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=718", "y:=616" "Class Name:=WebButton", "abs_x:=687", "abs_y:=571", "class:=Button", "disabled:=0", "height:=22", "html id:=btnSave", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""btnSave"" class=""Button"" onclick=""document.getElementById('a2').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=40", "x:=687", "y:=494" "Class Name:=WebButton", "abs_x:=635", "abs_y:=478", "class:=Button", "disabled:=0", "height:=23", "html id:=", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input class=""Button"" onclick=""document.getElementById('a3').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=635", "y:=401" "Class Name:=WebButton", "abs_x:=695", "abs_y:=558", "class:=Button", "disabled:=0", "height:=22", "html id:=BtnExternalPartySve", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""BtnExternalPartySve"" class=""Button"" onclick=""document.getElementById('a4').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=695", "y:=481" "Class Name:=WebButton", "abs_x:=672", "abs_y:=642", "class:=Button", "disabled:=0", "height:=22", "html id:=", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input class=""Button"" onclick=""document.getElementById('a5').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=40", "x:=672", "y:=565" Previous Item Next Item Connected to Microsoft Exchange

1 Answers  


what is output value in QTP and how it can be used in automation testing

0 Answers  


How do u override the meaning of a standard object in QTP?

1 Answers  


supose i hv to acsess some functionlaties of a test in 1 machin , some part other machin how can acsess?

0 Answers   IBM,


What is CMMP and CMMH?

0 Answers  


Categories