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
how to know no.of mails in our g mail by using vb-script
What is object spy in quicktest professional?
How to break the object spy ?
How can get count of list box?
what is the difference between development and testing
If I am scripting Web-based Surveys using QTP that open up differently but at the exact same point require a username and password can I automate that username and password for all the surveys some how using QTP?
what is the mail use of frame work(with detail). architecture for keyword driven frame work
What is QTP testing process?
what difference between runtime object and text object and what property they have. whether they have same properties or different properties.
How to use transactions in qtp?
What are the differences between quicktest professional (qtp) and winrunner?
how to find that a file has been completely downloaded or not? I told that "download Complete" pop up. but he told the tool doesn't recognize the pop up
What is Associate Repository in QTP 9.2 ?
How to data driven test for Win objects in QTP ?
Will there be any standards or requirements for page appearance and/or graphics throughout a site or parts of a site?