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 drop-down.
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 checks from the excel data.
Any guideline / code snippet for implementing the conditional checks is highly appreciated.