What is diff betwee datatable.importsheet "path" and
datatable.import
- 2 Answers
- 8238 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
how do u retrieve data from a database ? i.e. i want to retrieve 2nd record only from a database ? write code for this. by using ADODB connecton, RSOBJ and using a FOR loop we can retrieve all the records( ex: if we give query as select * from emp). but i want only 2nd record. so how to acheive this.
I installed QTP 9.5 on vista. Can someone please provide me the license key of the same. Thanks, Avi
whow much strong on VB and C?
Pls let me know how to find out creation time and index for the web application in descriptive programming?
I want to do Certification course in QTP. For this I request you to suggest the best Tutorial in PDF format. Hence, if possible, kinldy mail PDF file to my mail-ID: sushmapokhriyal79@gmail.com
How to perform cross platform testing and cross browser testing using qtp? Can you explain giving some example?
When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.
in qtp wha t is synchronisatin pt,what is the maximam time out
how you update scripts in qtp?
Hi we are running tests remotely from quality center and pushing tests into qtp boxes remotely, and it does execution but while uploading results back into quality center it hangs in qtp box.If any one come across similar problem, please send me details how to handle this. Thanks kris
Is it possible to call from one action to another action in qtp?
I am trying to write a descriptive program for clicking on a perticular link.For that i wanted an index or location of that object.But when I viewing through spy, There was no index property of that object.What to do for getting index value.How can I get index? please any one let me know.
WinRunner 
