Answer Posted / kishan

set xlo=createObject("Excel.Application")
xlo.visible=True
set wbo=xlo.Workbooks.open("D:\QTP\TestData\abcdef.xls")
set wso=wbo.worksheets("Sheet1")

rcnt=wso.usedRange.rowcount
ccnt=wso.usedRange.columncount

for i=1 to rcnt
for j=1 to ccnt
str=wso.cells(i,j)
position=instr(1,str,"expected_string")
if position > 1
print "Required String is in
cell"&wso.cells(i,j)
xlo.worksheets("sheet2").cells
(1,1)="expected_string"
end if
next
next

I need to pull the data from the page which in row, column vice into excel sheet, how can it be done using QTP? eg: Name Dept xyz gdty i need the same data to be exported in excel sheet.

2089

---

what is the difference betn QTP 8.0 AND PREVIOUS VERSION

2414

---

i have doubt suppose iam purly working in manual, when i will get work to do on sql and performence testing? pls any one clarify doubt?

1945

---

What is the difference between the design-time and run-time data tables?

1084

---

What is throw object?

2295

---

How to find the name of the machine where you are running your automation scripts in qtp?

970

---

How to replay a script in qtp?

1039

---

What is the use of ordinal identifier in qtp?

973

---

Explain about the test fusion report of quicktest professional (qtp)?

954

---

what is the difference between development and testing

3585

---

What is the qtp testing process?

1000

---

What is debugging? How you debug your script?

1132

---

What is the recovery scenario in qtp?

1004

---

what is impact analysis on regression testing?

2453

---

Where you get the run time data table?

991

---