I have some data in an excel file. I want to go to excel file then search a text (taken from website table), then get all the data of that row which will be used to fill table in browser.

Example : I want selenium to search ST0003 then get Name, Father’s Name of that student ID, so that I can fill this in college website.

sample data of excel

I thought I’ll get a student_id from website then paste it in existing excel sheet where I’ll fill other details using VLOOKUP but this method doesn’t look good.