How to compare the two cells data in same excel sheet?

[Priyanka]

Hi telerik team.

I want to compare the data for the same column in excel sheet.
I am adding the records in application using excel sheet, and i want to check the SSN number duplication.
If the SSN number is already exist for another patient then Fail should be displayed in excel sheet.
Please help me to find the solution.

Thanks......

[Byron]

Hello Priyanka,

It appears that you are inputting data into your target application using steps that are data-bound to an Excel spreadsheet. If you wish to confirm that the contents of the application match the expected value in the Excel spreadsheet, you can assert that the value of a target element matches that from the spreadsheet:

//Reference a column by name
Assert.IsTrue(ActiveBrowser.ContainsText(Data["Col1"].ToString()));

You can use a data-bound verification step as the condition for an if block, and then perform another verification step if the previous verification is true. 

If these suggestions do not accomplish your goal, please tell us more about your scenario. It appears that you want to test the case of SSN duplication. If the test inputs a duplicate SSN, should the application display an error message? Does the Excel spreadsheet contain a column that indicates whether the case contains a duplicate? A Jing video of the behavior may also help us diagnose your issue. Thanks for helping us advise you.

Regards,
Byron
the Telerik team