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
- 8155 Views
- I also Faced
- E-Mail Answers
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 are the mandatory and assistive properties of objects in QTP?What is attached text?Plz assist me with proper answer.
suppose i opened 6browsers and i want re-open the 4browser what is code for this..pls help me..
normally by going through the object properties in object spy we write descriptive programming(correct me if i am wrong). But how or from where can we get the object properties in the object spy?plzzzzzz do answer
regular expression in qtp standar check point for months from accepting months from january to december only
When i use paramateriztion for tickets in flight reservation application , the tes'll run for first iteration but for the second iteration it'll give this details, but the second iteration is failed. Pls anyone clarify it. Cannot find the "Agent Name:" object's parent "Login" (class Dialog). Verify that parent properties match an object currently displayed in your application.
can anyone answer this question ........in the DICTIONARY OBJECT....i created the dictionary object in reserved object ok....here i have some sets of values ...now i want to retrieve the item i done too ok.......here my question is now i saved the test and close the qtp tool ,again i opened now i retrieve the same item in the dictionary is it possible ????. friends when i try to do this i am getting empty message box i mean no value will be retrieved ......ans me any one plz...
How will you declare a variable in qtp?
How to handle dynamic objects in quicktest professional?
Is the qtp course will help to create a virtual object?
If I give some thousand tests to execute in two days what do you do?
w is datatable
Without using gui map editor we can recognize the application in winrunner ?
WinRunner 
