Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve particular cell data in excel sheet ?without importing method.
- 3 Answers
- 5677 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
how did u use automating testing tools in ur job?
how do you parameterize search button from the website? the page is a single winobject and i have made a virtual object button of search button but search box can't be converted into a winedit and if we try to convert it into winedit the value we enter in a searchbox appears as numbers in the script so we arent able to parameterize.help!!!
what is the difference betn QTP 8.0 AND PREVIOUS VERSION
what is clean sweep?
How u will do versioning in QTP?
Can we write winrunner language i.e TSL in QTP tool?
Please Don't mind .i want in detail the real time process i.e in each document what it contains.
What are the main differences of qtp and win runner?
"What are the common constrains that we need to consider when we prepare testcases for ASP application". Thanks in Advance...
Explain actions in qtp ?
what is output value in QTP and how it can be used in automation testing
how do u manipulating INI, DLL and / or registry files in support of your test environment? actually what do u mean by INI and DLL or registry files. plzzz its urgent do answer
Have you done batch testing in qtp? If yes how you are doing?
How to get the particular property value?
Can we use index on view?
