How to compare excel sheet each row values with web application.

Ask general questions here.
pupg
Posts: 1
Joined: Tue May 04, 2021 7:10 pm
Location: INDIA

How to compare excel sheet each row values with web application.

Post by pupg » Tue May 04, 2021 7:27 pm

Hello everyone,

I have a excel sheet containing ten rows. each rows has got it own cell values.
Now, on the other side I have a website where there is multiple textbox fields containing some values and I want to compare the data that appears in the web application text field against the excel row value.

How to perform this validation. ?
Attachments
Excelsheet value.jpg
Excelsheet value.jpg (47.11 KiB) Viewed 17 times
uivalues.PNG
uivalues.PNG (11.4 KiB) Viewed 17 times

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 6544
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: How to compare excel sheet each row values with web application.

Post by odklizec » Fri May 07, 2021 10:42 am

Hi,

The answer to your question is Data driven testing! ;) Please follow the User Guide - Data Driven testing chapter:
https://www.ranorex.com/help/latest/ran ... roduction/
And watch also this webinar:
https://www.ranorex.com/automated-testi ... n-testing/

Basically, you must create a repository element for each single input you wish to validate, assign variable to validation action for each element and then associate the variables with Excel file, containing the reference data. Each column in Excel should represents one element.
Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration