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
- 5753 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 |
Output values? i want a practical example
what are the different data driven types?
How to run scripts 1,29,3,5,7,2 scripts using test batch runner in QTP.... Ie...I wanted to run scripts not in an order 1,2,3,4,5...like that How it is possible using test batch runner... I dont want hardcoded script
What is environment variable in qtp and why to use it?
please tell me how to identify the index of the link in the web table .links are not constant.example i want to click the link in the inbox ,search the item and click the partcular mail.(mail links count is not constant)
Can anybody send me the code to get the RO property of the active screen in QTP while running?
How to do call a output parameter from one action to another action??/
what is defination of system testing?
3 Answers CodeArrow, Infosys, Omax,
If u r using descriptive programming to identify the object where do u write the script for those objects? do u write it in the expertview? plz do answer its urgent thanks advance.
Test script is generated and it is enhanced.It is required to be saved.But the disk space is insufficient.You are not permitted to delete any scripts.How are you going to save?
Could anyone help me for the below scenario: i am using the descriptive programming for my account, in which we have to generate the contract in the MS-word. when i generate this doc, we need to click on enable macros to continue further. but i am unable to make qtp to click on this. if anybody faced the problem like this??? pls help to get it resolved? Thanks in advance
What is descriptive programming?
WinRunner 
