Data set and demo webUI - Sample data in excel sheet (first row being column header) -
Demo layout -
Problem scenario - The data to be filled up is from an excel sheet, if the occupation is Entered (that is typed in), it will search in excel sheet's occupation column and populate the data in the name field, for example - After typing engineer, the names of engineers have been populated in the dropdown.
After the name is selected (manually), the Address will be automatically put in the address box from the excel sheets data. i.e. conditional checking from excel sheets data.
Now I can read from excel sheet using the jxl library, but I do not know how to implement the conditional checkings from the excel data.
Any guideline / code snippet for implementing the conditional checks is highly appreciated. Thank you.