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 |
What is regular expression?
How to explain a banking project in interview as a test engineer???
what are the frame work models of qtp?which frame work you follow in your company?and explain it process?
what is the difference between an Action and a function in real time
What is the difference between Mandatory and BaseFilter Properies..Anybody please answer me..Thanks in Advance
QTP identified the object but not performing the desired action???what could be the reason?????
what are recovery management techiniques?
2 Answers BirlaSoft, GL Noble Denton,
How u perform exception handling in QTp,what is other name for ths?
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?
What is the difference between gettoproperty and settoproperty?Explain with an example?
Can we directly start working with QTP without any knowledge on WinRunner? (After getting trsining on QTP)
What is the keyword view and expert view in qtp?