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

How many types of parameters are there?

0 Answers  

---

What is the default object synchronization timeout in qtp?

0 Answers  

---

Explain types of output values?

0 Answers  

---

How we can do Batch testing in QTP?

6 Answers   Kanbay,

---

Give some brief idea about a) Active x check b) Alt property check c) Applet object check d) Frame object check e) Multimedia links check f) Server side image check g) Table object check

1 Answers   CTS,

---

Hi,How to write regular expression for inbox(10) {here 10 is changing while playback}.tell me the pettern.

6 Answers  

---

i am trying to capture the URL from the open browser and store it. pls give me solution how we can do this in QTP. thanks

2 Answers  

---

How vl i prioritize the actions when i have 10 actions A1, A2, A3......A10. I want to run action as follows A1,A5,A6 and A10. How i can do it. Thanks in Advance to u.

7 Answers   IBM, Wipro,

---

can i compare two databases using QTP ?

0 Answers  

---

I had installed QTP 9.2. It is working fine but whenever I open QTP, it is trying to reinstall the below-mentioned files again and again "QTP92PS82UPGRADE.exe", "recogn.dll". If anybody has these files, please provide those files in this site or you can send that files to my mail id also (lravi4u@yahoo.com). If you don't know where the files will be in the QTP, search in the QTP software CD or path of QTP program installed (C:\Program Files\Mercury Interactive\QuickTest Professional)

0 Answers  

---

how to load vbs file to qtp through scripting. plz provide the code.....

2 Answers   IBM,

---

how to generate numbers in between to numbers suppose numbers in between 500 to 1000 in sequencies using vbscript

1 Answers  

---