Search in Excel / DataTable

[vramu1]

I'm writing test results in excel after comparing the values with in the code.
for example,

Code:

set ActValues = objExcel.ActiveWorkbook.Worksheets("ActualValuesNResults")
ActValues1 = ActValues.cells(1, 1)
ActValues2 = ActValues.cells(1, 2)
if ExpctValue1 = ActValues1 then
if ExpctValue2 = ActValues2 then
TestStatus = "Pass"
end if
else
TestStatus = "Fail"
End if
'writing test results in cell A3 in the "ActualValuesNResults" work sheet
ActValues.cells(1, 3) = TestStatus

hope this answers your question.

Cheers
Ram