Answer Posted / sonia

Set oexObj = CreateObject("Excel.Application")
Set oWb = oexObj.workbooks.open("c:\Input.xls")
Set sheet=oWb.worksheets(1)
row=sheet.usedrange.rows.count
col=sheet.usedrange.columns.count
For i=2 to row step 1
col1=0
For j=1 to col-3 step 1
colvalue = sheet.cells(i,j)
col1= col1+CInt(colvalue)
Next
col1=sheet.cells(i,4)
If CInt(col1) = CInt(sheet.cells(i,3)) Then
sheet.cells(i,5)="Pass"
Reporter.ReportEvent micPass, "Complate", "Expected Result"
&CInt(col1) &vbcrlf&" Actual Result."&vbcrlf& CInt(col1) =
CInt(sheet.cells(i,3))
else
sheet.cells(i,5)="Fail"
End If
Next
oWb.save
oexObj.quit
Set oWb=nothing
Set oexObj=nothing

Use this code it work very fine.

Write a script to customize the test results in PDF and HTML format.

2580

---

Explain actions in qtp ?

1039

---

What is the difference between analog and low level recording?

1138

---

Should have experience in framework means?

1929

---

If you are testing a web application then what will you test in that application?

2084

---

how to disable the pop ups through QTP using a script

2322

---

Shall we add Local Repository to shared object repository,if yes,how we add

7636

---

There are 10 rows in the datatable. How can we fetch 2 rows and then skip 3rd row. After that, pick 4th & 5th row and skip 6th row. Please share code

1769

---

How to create runtime property for an object?

2031

---

Explain step generator in qtp?

1152

---

What are the steps involved in recovery scenario wizard?

1027

---

Can QTP be used for GUI testing ?, We are using Java with MySQL and Operating system is Linux. We are NOT using the web.

2501

---

how to post xml data from QTP scripts to any application?

2022

---

What are the views available in qtp?

1077

---

How will you test a keyboard?

1139

---