Answer / 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

Answer / debashish

‘read excel sheet
dim xl,wb,ws
set xl=createobject("excel.application")
set wb=xl.workbooks.open("H:\asis excel.xlsx")
xl.DisplayAlerts=False
set ws=wb.worksheets("sheet1")
r=ws.usedrange.rows.count
c=ws.usedrange.columns.count
For i=1 to r
v=""
For j=1 to c
v=v &" "& ws.cells(i,j)
Next
msgbox v
'msgbox"-----------------------"
Next
'For i = 1 to r
' For j =1 to c
'msgbox ws.cells(i,j)

' Next
'next
wb.save
wb.close
set xl=nothing

Can we record a video in qtp recording??

1 Answers   BirlaSoft,

---

By using QTP can we record any log files written by the application which is in execution?

0 Answers   Ordain Solutions,

---

How we can add actions in the test using QTP?

5 Answers  

---

How QA specialist can identify when programmatic descriptions are useful?

0 Answers  

---

how you will do cookie testing using QTP?

2 Answers  

---

Explain the views in the QTP GUI?

0 Answers  

---

how to capture the run time values of web table.

3 Answers   CTS,

---

In Remote acess server how u run a test?

0 Answers  

---

What is meant by Environmental variables?2 types r there know…can u pls explain clearly?

1 Answers  

---

What is the use of Accessibility check point?

3 Answers  

---

Can we Run the Tests developed in QTP 8.2 in advanced versions like 9.0, 9.1, 9.2...etc.,

3 Answers   ADP,

---

What is a Dictionary object in QTP.?

1 Answers   Cap Gemini,

---