I am using DataTable.ImportSheet method to import the data
from an excel sheet to the Runtime DataTable of QTP.
here is my piece of code
DataTable.import("c:\DataSheet.xls","Members","Members")
The first row headings of Members sheet of DataSheet.xls
and Members sheet of QTp are matched.
but the QTP is taking very long time(approximately half an
hour) to import the data into runtime datatable even though
the DataSheet.xls has one or two rows in it.
Please let me know why this is happening and is there any
alternative for impoting the data into runtime datatable of
qtp ?
- 2 Answers
- 8403 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jyothi
Hi,
In the piece of codepasted above, it should be
DataTable.importsheet
("c:\DataSheet.xls","Members","Members")
where data is imported from sheet named 'Members' from
source excel to sheet named 'Masters' in destination (QTP,
if a sheet is already added in QTP script--
datatable.addsheet("Masters"))
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ivan murillo
Hi Srinivasa Reddy Nallamala, Were you able to solve this
problem? and if you could resolve it, how do you solve it?
thanks in advance
| Is This Answer Correct ? | 0 Yes | 0 No |
How you are developing the script? Using record and play back or manual?
With out using the task manager,how to close the application using vbscript and what is the statement?
what is object and child object.. explain ..if possible give some example for better understanding ..
Hi All, I am using QTP for one of the Desktop application which uses Keyboard inputs like 'Tab ,F7 etc' and also mouse (Click). After recording when i am running the Script ,it is not able to recognize the keyboard inputs like F7,Tab and mouse Click because of which either i have to skip that part or manually do the inputs. Please answer how can i make script more flexible so that it will recognize both keyboard and mouse operations.
Is the provision for integrating QTP with QC ,available from the version 9.0 onwards only or even 8.2 version has such provisions?
what r the main attributes of test automation?
Can we directly automate testscripts accrdoing to requirements? WHY ?
How does QTP identifies the object in the application Mainly objectives are three type's OF PROPERTIES namely
what is descriptive programming? what are the mandotory properties in qtp? what are libriry functions in qtp? what frame work you are using at your project? what is object repositery? what is our role as per qtp project is concerned as a software tester?
assume i have few url link how will i dynamically call then using descriptive programming?
give me the code for check point for validating application
Does QTP10 supports Windows 7OS +IE 9 combination? Which is the preffered combination ,Plz let me know?
WinRunner 
