Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9354 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a checkpoint? How many check points are there in qtp?
How QA specialist can identify when programmatic descriptions are useful?
Hi Friends, Would be great if you can provide the Model Question paper, Web site link or any reference s. Thanks & Regards, Byzoor,
What is active screen?
What is environment variable in qtp and why to use it?
what is the structure for the data driven framework
Have you used xml check point in your project? How?
How to use Environment parameterization? Explain with an example.
How can you identify the browser and its information using QTP script?
UFT 12.02 which ALM version will support
What are metrics and matrix?
What are the advantages of parameterization ?
i have two questions for regular expression :- Q1. I have date pattern eg-29/11/2011 29-11-2011 29.11.2011 Que- if any separator is there between date,month and year pattern should match else it should not match eg- pattern should not match in case of 2911-2011 Q2. let say i have a string and there is a number in between of that string eg.-Amount 30002.234 successfully credited to your account . now i have to match this pattern in such a way that even if decimal is not there pattern should match ,how i will do this using regular expression
What are the types of object repositories? Which one is you are using?
what is profile tool?
