Data extraction from web page


#1

Hi, I have to verify some data fields as mentioned in web page with the records as present in excel sheet and pass the results in the form of Pass or fail, if data verified.

**e.g. as per web page

Name- client Name
Language-English,Spanish
email-
*@gmail.com

As per excel sheet

Name-Client Name
Language-English,Spanish
email-
*@gmail.com

What should be the best approach for this?


#2

I would probably save web page results in dt1, excel sheet in dt2 and then use for each to iterate through dt1 and check if current row’s values exist in dt2:

dt2.Select("Name='" + row("Name").ToString + "' AND Language='" + row("Language").ToString + "' AND email='" + row("email").ToString + "'").Length>0