I have an excel with some 5 columns (say ID number, Name, branch, Date, description) in it and a table in an application .
In the application > I have a table which has values (say ID number, Date, Description) , Need to choose a value in a table by scrolling down and save it. I have to read the values in excel and for each record i have to select the value in the scroll down and select the appropriate value to save the record. (for eg, First record has ID num 001, and date : 02/21/2018… I have to go to application-> there will be values in the table like ID num 001 , 02/21/2018 and 002 , 01/30/2018 and 005 ,02/ 21/2018 etc.
I stored all values from excel in a datatable and while iterating -> for each record have to choose the correct combination from the table and select the value and save it.
Any suggestions on this?