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
- 9548 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 actually contain test report? can anybody post the test report
Hi friends I need to know about jubula automation tool. Is anybody know in bangalore where jubula tanning class is going on do let me know. Its urgent for me to learn that tool please help.
Please help me by providing the License key for QTP 9.2, at guru_aarya@yahoo.co.in Best Regards Gururaj.B
Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in
how can you do retesting (datadriven test) using notepad amd by using functions NOTE u should not use datatable methods
When to use shared and local object repository?
How are actions and functions different in QTP?
I want to open a Notepad window without recording a test and I do not want to use System utility Run command as well. How do I do this?
hi i have 4 yrs exp in manual and automation testing using QTP i need sample resumes plz can u send this mail id pbre1980@gmail.com
any body can you help me what is the script to automate an comand promt
Hi all Can u give me the link where we can download full version of qtp my mail id is karthic.venkitapathi@gmail.com
1.Write a CRITICAL test cases for calculator ? 2.What is the difference b/w FRS and SRS documents ? 3.What is Component ? 4.What is object ? 5.what is the difference b/w static and dynamic descriptive programming ?
write script for bitmap image?
Hi. please provide license key for QTP 9.2, I have windows XP on my machine Thanks in Advance, moreshwar
How can you identify the browser and its information using QTP script?
