How to retrieve particular cell data in excel sheet ?without importing method.
- 3 Answers
- 4595 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
In qtp, how you can remove the spaces from string?
How to customize qtp?
Step 3&4 are repeated until an the object in recognised uniquely.
Hi I have exp in manual testing and planning to move in automation testing qtp(9.2).So can help me how to automate customer relationship management tool using qtp and vb script this tool already developed so how can I test it whatever maintaining by development team like documents,various options just give the whole life cycle thanks in advance
Where is the Bitmap checkpoint information stored?
How to handle the exceptions using recovery secnario manager in quicktest professional (qtp)?
Can U Explain about QTP tool from older version to latest version also its differences?
Dear sir, i want to perform a QTP automated testing for mechancial engineering software like msc adams, msc nastran this softwares will help for mechanical engineering design analysis>> i know oad runner win runner, test director, QTp>> but i dont know how to use for automation
What is action? How many types of actions are there in qtp?
what and how to answer for the question "tell me about yourself ?" for 3 years experience. can anyone say inj detail please... its urgent
This is a question thats generally asked in every QTP interview. What were the problems that you faced during automation and how did you resolve them?
How QA specialist can identify when programmatic descriptions are useful?
Name the different types of recording modes?
What are the views available in qtp?
How can you send user defined messages to test report?
