how to compare excel data with gui data

[strannik]

Hi All,

We need to compare excel file which contains data with generating data on GUI. When we entering First name and last name the system will generate data based on person information and this data should equals excel data.
Do I need some how to open excel document to do comparison or it could be done differently.

Thank you all.

[strannik]

Please see attachments for GUI and Excel data.

Thank you.

[rawatankit6]

You can use Ranorex inbuilt and highly efficient excel data connectors. All you need to do is create a dynamic xpath for your items such as name etc and along with that create an excel data connector and use that connector to bind your data with that of excel.

[strannik]

Thank you rawatankit6,

Could you please give me example how to create a dynamic xpath for an item.