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
Answer / aruna
V CAN COPY THE CELL VALUES
GIVE THE CELL VALUE EX (1,1).COPY .............
| Is This Answer Correct ? | 4 Yes | 1 No |
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 |
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.
Can you import and export data from XLS and how?
keyword driven framework having how many folders? explain folders in detail?
How can we translate the steps between the Keyword and Expert Views?
Whar are the challenges do we face while testing web based applications using the automation tool QTP or any??
Can u explain about QTP framework
How to test whether the navigation i.e. from one page to another is working r not using QTP for web based application
Explain about Hybrid Framework
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.
what testing activities u may want to automate?
What is the limitation to XML Checkpoints?
how much space occupies in object respository by default?