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
what is the hierarchy to use properties in descriptive programming
Explain how you can replace string in qtp?
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
What is the synchronization point in qtp?
regular expression in qtp standar check point for months from accepting months from january to december only
Explain the new feature of UFT regarding the export of test results?
hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.
tell me abt a time when u had to go above &beyind the call of duty to get the job done
Could i know how how to explain keyword driven framework in interview? If any body knows plz send the explanation.
Hi Samrat, Thank u very much, what u said it is right.
Is there anyway to automatically update the Datasource name in Database Checkpoints object when we migrate tests to a new release?
Explain the types of properties that quick test learns while recording?
What is the use of defining a newobject in the object repository "Define New TestOject". How to use this further. If we define new testobject, how can it recognizes the objects properties of any application.
What is the expert view?
Where you are storing your script?