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

Can any body explain me how to prepare QTP frame work with an example?? alexander.gdk@gmail.com

1 Answers  


I am getting an error "failed to open the XML checkpoint result viewer" in result window,after clicking on "View XML checkpoint results".Someone suggest me settings,if any...

0 Answers  


how to recall a function in QTP?

3 Answers   Ordain Solutions,


I install .Net Add-Ins in my system. It installed properly. But all the objects are recognizing as window objects only. But it has to recognize as swf objects. In Record and Run setting i selected 'Record and run test on any open browser' and Record and run test on any open Windows-based application' Can any one tell what setting i have to do to recognize objects correctly as swf...? Please give some suggestions..?

1 Answers  


Explain the qtp test phases.

0 Answers  


tell me abt a time when u had to go above &beyind the call of duty to get the job done

0 Answers  


• Re –Engineering the regression testing from 0% to 60% automation. This has saved 4-mandays in every release. what doeas this statement means

2 Answers   Infosys,


Hi all, i have installed QTP8.2 in my system. but script is not generating while recording. What is the problem? is any file missing? pls let me know anybody...Thnaks

3 Answers  


Is it possible to map an image as standard Object or u've to treat as virtual? how to map an Dynamic image into standard object?

1 Answers  


In a webtable,a list of values are there,rightnow one values shows,later random another values shows,but how to retrieve the random value in webtable.

1 Answers   HP,


What is ObjectParamater?

0 Answers   CTS,


we have 10 automation scripts. how to call them from one main script.

2 Answers  


Categories