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

Currently i have designed my script based on the test cases present in Quality Center. I want to run my script from quality center. Can anyone help me to get the code which will connect QTP with Quality Center and execute the test cases?

1 Answers  


What In-string function will do?

1 Answers  


somebody please say me why we go for using regular expressions,actions.what is the main and exact use of this in real time applications.real time testers pls answer my question with example if u can

4 Answers  


Hi All As per the requirements i have to copy the data from word document to excel sheet using the QTP Note : Data in word document is in tabular format i.e there is 80 rows and 5 columns table Can any body provide code for this ? Thanks in advance Regards Test123Test

1 Answers  


How many types of run modes are there in qtp?

0 Answers  






Why is Client side image is preferred over server side image?

0 Answers  


Explain the check points in quicktest professional (qtp)?

0 Answers  


When should u feel that u can stop testing now? The following are few of the common Test Stop criteria:

2 Answers  


If a object property is changed in the application. where it should be updated in QTP... Pls anybody can give the answer.. Thanks in advance...

4 Answers   Navis,


Can QTP be used for GUI testing ?, We are using Java with MySQL and Operating system is Linux. We are NOT using the web.

0 Answers   IBM,


When testing a web application, the url for each page changes, so using QTP how do u handle this scenario. If anyone knows please answer in detail about the whole procedure. Thanks a lot.

3 Answers  


how to fetch the values from grid? & qtp recogniges that grid as a webelement? what u do?

0 Answers   IBM,


Categories