Read the data into datatable and then perform your actions and write the data back to excel
For example if you want to update all rows with name as ANDREW then use a for loop and write a if condition to check the name andrew ans if yea then update the respective column
You can do the same by using for eqch row in excel also and use a if condition like currentrow(“name”).ToString.equals(“Andrew”)
Cheers