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

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 ?

Question Posted / srinivasa reddy nallamala

2 Answers
8680 Views
I also Faced
E-Mail Answers

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