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

hi all can any body explain how to write the script for finding the mandatory fields which are having [red Astrik sign (*)]

0 Answers   Accenture,


Explain about Table and DB Checkpoints?

1 Answers   Crea,


Hi Friends...this is surendra..recently i joined automation team ...Please send me some documents regarding VB script ...and where can i learn VB script... This is My mail id: surendra.mamilla@gmail.com... please send to my mail.... Thanx in advance surendra.

1 Answers  


What type of VB script u had done in expert view?

1 Answers   HCL,


Can we test GUI of the application using QTP.? How.?If possible briefly explain process.?

1 Answers   Wipro,


Please explain me frameworks & how to generate the scripts in framework

0 Answers   ADP,


Suppose U change the script whether it affect the object properties of the object in the object repository

4 Answers   IBM,


You have an application version 1 with 5 combo boxes, Developers develop version 2. Here they replaced bottom 3 combo boxes with each other. While executing the Test script for version1 no errors. When we execute the Test script for version2 that QTP showing the error message "Object not identified" remember no property changed in version 2, ordinal identifier also disabled. Find what properties might change here in this scenario

6 Answers   ADP,


pls dont join MIndq nageshwar rao...Nageshwar rao sir didnt teach QTP indepth...he teach basics only...atleast he dont know about INSTR concept...this concept take min 30 min...buthe teach 3 min only...like this so many concepts are missing in class. IN CLASS ROOM NAGESHWAR RAO SIR HIPNATIZE THE STUDENTS....WITH OTHER ISSUES.. dont join... look other institutes...this is my personal openion share your comments thank u

1 Answers   Mind Q Systems,


How should I get results when I run scripts in a Batch mode

1 Answers   TCS,


I am new with QTP. Is anybody could tell me where I can find a good tutorial with lots of samples?

0 Answers  


In a page i have N number of links at a time i would like to open those links by using QTP?how to do that?

2 Answers   Wipro,


Categories