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?
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 |
hi i have one isuue on selecting webcheckbox .there are 15 wecheckboxex i want to select every time 9 th one how can i select plese help me regards balaji
I came across Good question ..... Write a script to only download pdf's if there are 20 links on a page. Kindly reply these type of questions are pretty challenging..
I have a tool bar where 5 different buttons are placed, but these buttons are not traceable hence i have created a virtual object on save button of this toolbar. Now pls tell me how to use this virtual object while write script.
I have a tool for automation testing (eg:qtp).I have two functionality(A & B) to test.A is tested once in a year. B is tested everyday. At present i have the money and resource availability to automate only one functionality.Which one will u suggest and why?
i have an external excel datasheet where it only contains 3 rows. after qtp executed the code to import the datasheet, the datatable getrowcount method now gives me a different value, lets say 60,000+ instead of only 3. i did not have any values starting from row 4 of my excel file. why is this happening? this also results to the qtp report to load for a very long time.
Username field having some string mistake like"user naem".what type of testing i prefer to test spell check.
some times we write user define functions.where we write main and sub program,how,where to insert the functions in qtp?
how to compare two excell sheets by using vbscript??
what is the general issues faced while using automation tool Qtp9.0
How to differentiate the webedit field like user name and password? Please tell any other best answer is ther
How to Import data from a ".xls" file to Data table during Runtime.
Can we test internet application using QTP?