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

Have you done batch testing in qtp? If yes how you are doing?

929

---

What is the limitation to XML Checkpoints?

2063

---

How many types of parameters are available in quicktest professional?

1006

---

Does QTP record on Objects created on XWindows Environment?

2201

---

Hi Friends this is kumar i would like to request to all of you ,please help me to explain real time project with using qtp scripts i know basics of qtp but it won't workout on interviews,pls help awating to reply.

1826

---

what are the mandatory properties for a tex boxc (scenario?)

2005

---

How do you create regression test packs?

1205

---

Can we Test Welcome Screens and Process Images with QTP

1943

---

I want to do Certification course in QTP. For this I request you to suggest the best Tutorial in PDF format. Hence, if possible, kinldy mail PDF file to my mail-ID: sushmapokhriyal79@gmail.com

1949

---

How QTP identify the system time that's changes every seconds?

1054

---

Explain in brief about the quicktest professional (qtp) automation object model?

988

---

What is an object repository?

1051

---

I would like to directly import XL file and work on that XL file directly in QTp script in that XL sheet need to allocate workbench,XL sheet and generate two bar graphs automatically how to do that? plz let me know any answers?

2065

---

How to read a text file from QC using QTP. I would like to do something like this. But instead read a file from QC and NOT from my local drive. Set fso = CreateObject("Scripting.FileSystemObject") Set InputFile = fso.OpenTextFile("C:\test.txt", ForReading) Thanks

3262

---

desribe a situation where u faced a stressful situation and how did u cope with it

1857

---