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 ?

Answers were Sorted based on User's Feedback



I am using DataTable.ImportSheet method to import the data from an excel sheet to the Runtime Data..

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

I am using DataTable.ImportSheet method to import the data from an excel sheet to the Runtime Data..

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

Post New Answer

More QTP Interview Questions

what is the mail use of frame work(with detail). architecture for keyword driven frame work

0 Answers   Persistent,


how to find that a file has been completely downloaded or not? I told that "download Complete" pop up. but he told the tool doesn't recognize the pop up

1 Answers   Mphasis,


Can anybody help me for vb script in qtp? give me examples for practice plz.

0 Answers  


What are some test assets and related extensions of qtp?

0 Answers  


How to test menu options using qtp

2 Answers  


Which environments does qtp support?

0 Answers  


What is the difference between Recover Scenario(screen) and on Error Resume Next(code)

4 Answers  


How to send QTP test results to an email...(with out using Quality Center)?

11 Answers  


how can we test load time of an page in webtesting?

3 Answers   Ordain Solutions,


Please clarify Automation and QTP both(names) are same or diff?

1 Answers  


What is expert view and keyword view?

0 Answers  


Is it possible to merge two object repository files in qtp?

0 Answers  


Categories