How to retrieve particular cell data in excel sheet ?without importing method.
Answer Posted / pravati
set excel=createobject("excel.application")
excel.application.visible=true
excel.workbook.open("path of the excelsheet")
set mysheet=excel.activeworkbook.worksheets("sheet name")
value=mysheet.cells(row no,colmn no).value
msgbox value
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what you mean by artifact,milestone...
can any body plz help by sending the qtp docs and qtp ppt's? this is my mail id:murali.padeti@gmail.com
How is the Bitmap checkpoint different from Image checkpoint?
What are the different recording modes and how do they work?
what are the utilities and drivers
What is the difference between run time object and test object in QTP?
How do you do batch testing in wr and is it possible to do in qtp, if so explain?
What do you mean by iteration?
could any help me please, how to work on visual foxpro application using UFT
How many types of trigger events are there in qtp?
suppose in the middle of the project QTP will not work properly, then what do u do? and ur team?
What is action? How many types of actions are there in qtp?
can i compare two databases using QTP ?
What is the basic concept of quicktest professional?
How can you close the second opened browser?