Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 frame work your using in automation testing

2 Answers  


• What type of testing questions will be asked for 2+ yrs exp people in interview?

0 Answers  


Hi, actually I completed Btech(CS). But i Will go to admin (Facility) interview. So, If Interviewer asking like " Why You choose this field". What we say? pLZ PLZ PLZ PLZ >............................................Send me.....

2 Answers  


I Selected for TCS-Chennai(Contract to hire) position plz suggest me whether i have to join or not

2 Answers   TCS,


Is it possible to run QTP scripts created in IE 6.0 in IE 7.0?

4 Answers   TCS,


What does it mean when a check point is in red color? What do you do?

0 Answers  


Can anyone explain me about child objects in detail;when they are used and why do we need them ? please give me sample code for this if possible.

1 Answers   Virtusa,


How to integrate QTP with QC using VB Scripting? What are the prerequisites to connect with QC?

0 Answers   CTS, Nabard,


Hi any body can tell me the in detaled information about Description.Create() thanks in advance

2 Answers  


What scripting language QTP of?

4 Answers  


How you can delete excel file in qtp?

0 Answers  


There are some links on the page,count and click those links and check the text on the page displayed on clicking the link.write script for this scenario.

0 Answers  


Categories