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...


How do you copy a value from a cell in an msexcel sheet saved
on the desktop into QTP's datatable when the co-ordinates of
cell are given?

Answers were Sorted based on User's Feedback



How do you copy a value from a cell in an msexcel sheet saved on the desktop into QTP's datat..

Answer / aruna

V CAN COPY THE CELL VALUES
GIVE THE CELL VALUE EX (1,1).COPY .............

Is This Answer Correct ?    4 Yes 1 No

How do you copy a value from a cell in an msexcel sheet saved on the desktop into QTP's datat..

Answer / pankaj

Call the excel first :
Set xl = createobject("excel.application")
Set wb = xl.Workbooks.Open("D:\test.xls")
Set ws=wb.Worksheets(sheet1)
datatable("Colname","Sheetname")=ws.cells(i,j) ' i and j
'would be known row and col into excel

Try this it will work for more doubt in QTP you can directly
post me question on my blog
http://quality2deliver.blogspot.com

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More QTP Interview Questions

I know the Basic QTP. But I wanted to learn descriptive programming in QTP. Without Object Repository how we can develop a script? I wanted to do one real time project using QTP. If you know this type of training is available in pune then let me know the address.

0 Answers  


Can you import and export data from XLS and how?

4 Answers  


keyword driven framework having how many folders? explain folders in detail?

1 Answers  


How can we translate the steps between the Keyword and Expert Views?

1 Answers  


Whar are the challenges do we face while testing web based applications using the automation tool QTP or any??

0 Answers  


Can u explain about QTP framework

10 Answers   ACS,


How to test whether the navigation i.e. from one page to another is working r not using QTP for web based application

1 Answers  


Explain about Hybrid Framework

2 Answers   IBM,


can we install qtp on server machine and do automation of application which is installed on client machine.If yes then how? If no then is there any other automation tool for this (client-server) senario.

4 Answers  


what testing activities u may want to automate?

2 Answers  


What is the limitation to XML Checkpoints?

1 Answers  


how much space occupies in object respository by default?

5 Answers   VSoft,


Categories