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
- 5808 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
I hav installed QTP8.2, im working on webapplication, while running the script giving error msg like "QTPro.exe generated errors and will be closed by windows. You will restart the program. An error log is being created". Pls anybody what is the problem, what i have to do for this? Thanks...
How many ways is to parameterize the value?
What is meant by Output Value in UFT?
Explain Descriptive Programming Types with Examples?
Brief the process of testing with UFT?
How many ways we can parameterize data in quicktest professional (qtp)?
In an interview, what r the general questions asked in SQL which is realted to testing ?pls give me anwser to this question?
What is the Difference between test object and run time object?
How to delete an object from the object repository?
What is quicktest professional (qtp window?
What is the parameterization? Give one example?
What are the two types of repositories available, explain them?
What contains Data Driven Framework document in qtp?
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
how to acess a test in RSA?
