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?
Answer Posted / 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 View All Answers
i need qtp tutorial. pls send it to sridhar.k151@g mail.com
How can you send user defined messages to test report?
What is checkpoints for qtp?
How many tabs are available in debug viewer pane?
How to handle the exceptions using the recovery scenario manager in qtp?
How we can import data from database?
If you are testing a web application then what will you test in that application?
How did you use regular expressions in QTP and also in WR?
How to create Reusable and Multiple Actions?
What is quick test pro?
is there any addin for remedy user application
How to analyzing test results using quicktest professional (qtp)?
What are the views available in quicktest professional (qtp)?
how can i pass a "automation script" as a parameter in a function give me need full suggestion thank inadvance
Some time when i wanna learn the object i face issue like i am not able learn the object in proper manner... eg:for text bo on web page it should learn as webedit but some times it reads as winobject:internetexpoler-server, because of this i have to uninstall the qtp and re-install it again when i do this it reads the object perfectly.....plz suggest the soln