Fetching Data from Webpage and comparing with Excel report

[Abishek]

Hello All,

I have a excel report contains some employee details as below.

I need to capture the each data from the below web page and need to compare with each cell of excel report.

In what ways we can acheive this?

Thanks in Advance!!

[Rahul_Pasupuleti]

Hi Abishek,

Store each of the data in a variable.
and for each row in Excel sheet, compare the web page data with each column.

For example
Effective date value stored in ed

for each row in excel
if
row.item(“EffectiveDate”)=ed
then
writeline(“Effective date is valid”)