Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve particular cell data in excel sheet ?without importing method.
- 3 Answers
- 5653 Views
- I also Faced
- E-Mail Answers
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
Why we load add-ins in qtp?
I am Facing Issues with learing datepicker 1)when i first learn datepicker as current system date . 2)if i wanna runtime datepicker value it gives error
How do you handle multiple banners(at the top the page, the banner is scrolling) in a web page(Dont take the name property(regular expression))
How can I import environment from a file on disk?
What is difference between Recording time object identification and Run time (Execution) time.
Hi All, I have QTP installed on my machine but the application under test (AUT) is on remote desktop.My scenarios is like that,it should contain following steps. 1)Automatically it should click on start and then on remote desktop connection. 2)it should enter the IP address and then connect to remote desktop. 3)and then it should be able to record the application in remote machine and then run it also. Can somebody tell me how to record the application which is in remote machine.
is it possible to add sheets to excel at runtime
How do you compare the structure of 2 tables in database and check whether they are similar using qtp.
What is the expert view?
what is meant by source control?
what r the verstions from 1st to present (verstions) of mercury tools (like winrunner,QTP,Loadrunner) ? Chandana
How to start recording using quicktest professional?
What are the different types of action?
What is the difference in the global and action sheet in qtp?
Step 3&4 are repeated until an the object in recognised uniquely.
