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 ?
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 |
what is Synchronization point in QTP?Can anybody give a perfect example on it Thanks in advance
Check point what is how many types of checkpoint and explain
i need the licence key for QTP V9.5 can anyone help me on getting this?
How to find the path of folder in which the test is saved in qtp?
how do u manipulating INI, DLL and / or registry files in support of your test environment? actually what do u mean by INI and DLL or registry files. plzzz its urgent do answer
What are the types of object repository in qtp?
how to merge object repositories in qtp for n different applications
How to connect the real time application application with the QTP?
Explain about the quicktest professional (qtp) automation object model?
What are the abbreviations for tsr and mtr?
17 Answers Ordain Solutions, TSR,
what is use of the object repository?
How to execute a WinRunner Script in QTP?