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 ?
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
whare exactly we have to use functions and sub routain
how to write the descriptive programming in QTP for remove the object value and substitute, with a variable then call the validation from excel
Hi Friends, How many types of Data Bases available in market... What is the diff. while using Syabase and Oracle in a Project... ? and what is the main diff. of Syabase and Oracle databases... ? Thanx in advance..
I am in .Net development for past 3.5 years and want to enter in to automated testing and learn QTP. For this I need some good tutorial for beginners. I will be really greatful if any one has and they can send it to me on this address- ruchidureja@gmail.com
images are dynamically changes how to compare two images with out using the bitmap
How to use conditional loops in qtp ?
Is text area check point supports for web applications?
PLEASE TELL ME WHEN DO YOU USE THE OBJECT SPY AT RUN TIME
Can we use index on view?
Suppose I created one object as virtual object? That object is applicable to that test? Or all the tests?
What is system testing and what are the different types of tests you perform in system testing?
What the differences are and best practical application of Object Repository?
diff between qtp versions from 8.5
How do we analyze the checkpoint results?
Hi friends did any budy attend accenture system test for qtp? if any budy pls drop questions.not only accenture any other mnc company which you attended system test(QTP)?it may helpful to others also