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

How can you send user defined messages to test report?

1044

---

What is recovery scenario in qtp?

994

---

what is run action?

1915

---

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 ?

2262

---

How to perform cross platform testing and cross browser testing using qtp? Can you explain giving some example?

1012

---

What is the architecture of your project? Can any one answer for this question plz........

1874

---

i have asked earlier only one question how to test web application using QTp plz send me the answer quickly

2127

---

Differences between quicktest professional (qtp) and winrunner?

1164

---

How to find operating system information using the qtp script?

1082

---

what is stepin & stepout?

1848

---

How you create new action in qtp?

1127

---

How smart identification works in qtp ?

986

---

Explain the types of object repositorys in qtp?

1086

---

What is the XML file architecture ?

1991

---

how interviews will be on QTP?

1930

---