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
- 5936 Views
- Oracle, I also Faced
- E-Mail Answers
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 |
What is diffrence between Global variables and Environment variables...Anybody can give me answer..Thanks in advance..
Hi Friends, If you got one Bug , and you are insert that bug in bug tracking tool , and you need to attach SC's (screen shots) also. how to tae SC's , in your organization any separate tools available to take SC's. please provide Ans. its urgent... Thanx in advance
Connect to QC using AOM.
Presently i am working on QTP 8.2 Version,i want to know features in 9.2 version, because i have not sufficient time to put the effort on the 9.2 version
Hi, Can any body please tell me how to create framework in qtp & where i can get some material to learn about it. regards, rahulT
I have faced one issues while doing test in QTP. I have described the scenario below. 1. I have to test web application.In that i want to give input of drop down values in the application. 2. Suppose Drop down has 5 value "A,B,C,D,E".I would like to give value from data table of QTP. 3. I have changed the drop down value as variable in Keyword view and given values in data table "A,B,C,D,E" as one below one. 4. While i am running the script it could not identify the drop down value which is in Data Table.It shows message. How to make value identify by QTP?
What are the main attributes of test automation?
str="ramanareddy12345@gmail.com"to count alphabets,numarics and special charcters pls any one knows send to answer
What ate the Technologies supported by QTP?
Both static and dynamic arrays are handled by the vb script. Is it true?
Can you tell me any books or websites to learn VB Script for QTP ??
what is the difference between parameters and arguments?
WinRunner 
