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



How do you copy a value from a cell in an msexcel sheet saved on the desktop into QTP's datat..

Answer / aruna

V CAN COPY THE CELL VALUES
GIVE THE CELL VALUE EX (1,1).COPY .............

Is This Answer Correct ?    4 Yes 1 No

How do you copy a value from a cell in an msexcel sheet saved on the desktop into QTP's datat..

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

Post New Answer

More QTP Interview Questions

What is regular expression?

0 Answers  


How to explain a banking project in interview as a test engineer???

0 Answers   Accenture,


what are the frame work models of qtp?which frame work you follow in your company?and explain it process?

0 Answers   Covansys,


what is the difference between an Action and a function in real time

4 Answers  


What is the difference between Mandatory and BaseFilter Properies..Anybody please answer me..Thanks in Advance

3 Answers   BirlaSoft,






QTP identified the object but not performing the desired action???what could be the reason?????

1 Answers   Mphasis,


what are recovery management techiniques?

2 Answers   BirlaSoft, GL Noble Denton,


How u perform exception handling in QTp,what is other name for ths?

2 Answers  


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?

3 Answers   Wipro,


What is the difference between gettoproperty and settoproperty?Explain with an example?

4 Answers   QQS, Satyam,


Can we directly start working with QTP without any knowledge on WinRunner? (After getting trsining on QTP)

1 Answers  


What is the keyword view and expert view in qtp?

0 Answers  


Categories