Answer Posted / bindu
'Create Excel Object
Set excel=createobject("excel.application")
'Make it Visible
excel.Visible=True
'Open the Excel File
Set workbook=excel.Workbooks.Open("D:\excel.xls")
'Get the Control on Specific Sheet
Set worksheet1=workbook.Worksheets.Item("Sheet1")
'get rows count
a1=worksheet1.usedrange.rows.count
'get columns count
a2=worksheet1.usedrange.columns.count
msgbox a1
msgbox a2
For i=1 to a1
celltext=" "
For j=1 to a2
celltext=worksheet1.cells(i,j)
msgbox celltext
Next
Next
workbook1.close
set excel=nothing
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can you send user defined messages to test report?
What is recovery scenario in qtp?
what is run action?
I am trying to install QTP 9.5 but i am getting error message saying that ("Path is \QuickTest Professional\bin\vb_init.exe") vb_init.exe file is not find. can anybody give me the advise what to do ?
How to perform cross platform testing and cross browser testing using qtp? Can you explain giving some example?
What is the architecture of your project? Can any one answer for this question plz........
i have asked earlier only one question how to test web application using QTp plz send me the answer quickly
Differences between quicktest professional (qtp) and winrunner?
How to find operating system information using the qtp script?
what is stepin & stepout?
How you create new action in qtp?
How smart identification works in qtp ?
Explain the types of object repositorys in qtp?
What is the XML file architecture ?
how interviews will be on QTP?