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

How to Save your test using QTP?

1 Answers  


I am testing a Website thelancet and create a description for searching "health" in search edit box.But my description failed on last two lines.Can anybody solve this

1 Answers  


I have multiple radio buttons i need to select a radio buton and i dont want to hard code i have a generic function for it there i have used select#0 so it selects first radio button but for other script i want to select the 4th radio button how i can make it still more generic

4 Answers   Accenture, Acentia, LM,


Define QTP ?

10 Answers   TCS,


By using QTP, How do you test a frame in a web page?

4 Answers   TCS,


How to do call a output parameter from one action to another action??/

0 Answers   TCS,


There is web page with the webtable,this contains some data, how do you manipulate the data.

2 Answers   Tech Mahindra,


Could you suggest me best coaching for automation in Delhi or nearby area?

0 Answers  


which checkpoint we use to validate yahoo login screen window after login with ur id and password in qtp

8 Answers   Covansys,


Tell me few important difference Between QTP and WinRunner?

9 Answers   TCS,


HI, Based On The Information Below Write A Data Driven test Script Edit Box 1 Should take Value From Num1 Column Edit Box 2 Should take Value From Num2 Column Click On Add Button, Get The Value Of Exp res Column, Get Value From Actual Result Edit Box , Compare Two Values, Write Pass / Fail Value Into Result Column Thanks In Advance... Kavitha Input.Xls Num1 Num2 Exp res Act res Result 10 30 40 40 Pass 50 40 90 90.5 - - - - - - - - - - - - - - - -

5 Answers   UHG,


Hi frnds, for ex.. we got a job in wipro, they will give me one mail id.. "Rameshkumar@wipro.com", where to open this mail id..in which sw ? or outlook?

1 Answers  


Categories