how to compare excel data with gui data

Ask general questions here.
strannik
Posts: 60
Joined: Tue Apr 29, 2014 3:00 pm

how to compare excel data with gui data

Post by strannik » Tue Nov 18, 2014 1:18 am

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
Posts: 60
Joined: Tue Apr 29, 2014 3:00 pm

Re: how to compare excel data with gui data

Post by strannik » Tue Nov 18, 2014 3:34 pm

Please see attachments for GUI and Excel data.

Thank you.
Attachments
MVR.PNG
MVR.PNG (24.14 KiB) Viewed 1372 times
exccel_data.PNG
exccel_data.PNG (17.56 KiB) Viewed 1372 times

rawatankit6
Posts: 11
Joined: Thu Aug 21, 2014 7:50 pm

Re: how to compare excel data with gui data

Post by rawatankit6 » Tue Nov 18, 2014 7:19 pm

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. :D

strannik
Posts: 60
Joined: Tue Apr 29, 2014 3:00 pm

Re: how to compare excel data with gui data

Post by strannik » Tue Nov 18, 2014 8:41 pm

Thank you rawatankit6,

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