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

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

4 Answers  


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..

4 Answers   Keane India Ltd,


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.

0 Answers   IBM,


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?

2 Answers   TCS,


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.

0 Answers  






Username field having some string mistake like"user naem".what type of testing i prefer to test spell check.

6 Answers   GE,


some times we write user define functions.where we write main and sub program,how,where to insert the functions in qtp?

2 Answers   GE,


how to compare two excell sheets by using vbscript??

2 Answers  


what is the general issues faced while using automation tool Qtp9.0

1 Answers   TCS,


How to differentiate the webedit field like user name and password? Please tell any other best answer is ther

3 Answers   Navis,


How to Import data from a ".xls" file to Data table during Runtime.

1 Answers  


Can we test internet application using QTP?

2 Answers   Quinnox,


Categories