Answer Posted / nath .t

this example add the first two columns(Example Num1 and
Num2), added value stored in Act res column and take the
Exp res value, compare the two values and put result in
result column as pass or fail.

before execution:
example: Input.Xls
Num1 Num2 Exp res Act res Result
10 30 40 - -
50 40 90 - -
- - - - -
- - - - -
- - - - -

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
sheet.cells(i,4)=col1
If cint(col1) = cint(sheet.cells(i, 3)) Then
sheet.cells(i, 5) = "Pass"
else
sheet.cells(i, 5) = "Fail"
End If
Next
oWb.save
oExObj.quit
Set oWb = nothing
Set oExObj = nothing

after execution:Input.Xls

Num1 Num2 Exp res Act res Result
10 30 40 40 Pass
50 40 100 90 Fail
- - - - -
- - - - -
- - - - -

Kavitha can modify above code as per criteria this is very
helpful for ur scenario.

What is throw Object?

2231

---

hi nani my doubt is how does qtp process metrix related to software process.

2064

---

Explain xml checkpoints.

1194

---

How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What's the difference between them? How to handle script issues?

1092

---

How would you export a script from one pc to another in qtp?

1151

---

How is recording done when a application is over lapping the QTP application it gives a message object not recorded

2133

---

what type of automation is follwed in the project?

1958

---

For example you are checking bit map check point before coming to the results. How can you say it is passed? Or failed? Anyways?

1077

---

What is text/text area checkpoint?

1108

---

Where we use data driver in qtp?

1105

---

Suppose I want fail that check point? How can you do that?

1139

---

what QTP Options do you know?

3440

---

How do I lauch my test website using code from qtp in different environmet, uat and PPTE?

2076

---

What is the architecture of your project? Can any one answer for this question plz........

1929

---

How to carry out bit map check points in QTP

2238

---