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 the frame work your using in automation testing
• What type of testing questions will be asked for 2+ yrs exp people in interview?
Hi, actually I completed Btech(CS). But i Will go to admin (Facility) interview. So, If Interviewer asking like " Why You choose this field". What we say? pLZ PLZ PLZ PLZ >............................................Send me.....
I Selected for TCS-Chennai(Contract to hire) position plz suggest me whether i have to join or not
Is it possible to run QTP scripts created in IE 6.0 in IE 7.0?
What does it mean when a check point is in red color? What do you do?
Can anyone explain me about child objects in detail;when they are used and why do we need them ? please give me sample code for this if possible.
How to integrate QTP with QC using VB Scripting? What are the prerequisites to connect with QC?
Hi any body can tell me the in detaled information about Description.Create() thanks in advance
What scripting language QTP of?
How you can delete excel file in qtp?
There are some links on the page,count and click those links and check the text on the page displayed on clicking the link.write script for this scenario.