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?
- 2 Answers
- 5934 Views
- Oracle, I also Faced
- E-Mail Answers
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 can i initiate the objects to find uniquely in OR
How to Test the mainframe application?
Which scripting language used by quicktest professional (qtp)?
Pls can anybody send me the Recent Technical and Interview Questions Which were asked in IBM(QTP)Automation PLZZZZZZZZZ
How to capture dynamic values in load runner and how Each of the captured values are to be written to a text file (c:\temp\LoadRunner1.txt)
what is clean sweep?
why you have standardized functions? plzzz guys with real time exp. do answer
Explain about Test Fusion Report of QTP?
Hello Everyone, Please provide me the practical example of business component concept of QTP.Like how to create business component,how to connect the quality center etc.... Thanks in advance, Gaytri
what is description object?
how can we test the Triggers, Cursors, Indexes while doing Database testing in DTP??
How to analyzing test results using quicktest professional (qtp)?
what difference between runtime object and text object and what property they have. whether they have same properties or different properties.
can test automation improve test effectiveness?
Is it possible to call win runner script in qtp?
