How to use Java GUI to access a table in Excel?

Question

Java

I started learning Java and yesterday before going to bed I had an idea to write an application. The essence of the application is as follows: we have an Excel table in which there are several columns "Employee name", "Department name", "Salary", "Experience" (names and quantity are not important) I want to write a GUI when opening which the user will be prompted to enter the employee's name and click OK, after that, if the employee is found, then in the same GUI a line with information about the employee and two buttons "close" and "repeat the request" will appear, and if the employee is not found, then the "repeat request" button will appear. The question is, how do I interact with Excel? Well, I would be glad if someone could help with the code.

Answer 1

Google has a lot of information on parsing Excel with Java. For example, here: devcolibri.com/1716
In fact: at the start of the program, parse the entire excelin into a thread, such as a dictionary, and already work with it from the GUI. You can try without Excel for now - fill the structure with data from the code.

Answer 2

I would display the entire table in the GUI. And the entire table can be viewed and searched. In this case, a table model is built according to data from Excel, and then this model is drawn in a GUI table.