Iparam Finder Search Functionality
The search functionality has officially been implemented into the the tool!
I was able to find an API developed by Apache called Apache POI. This allows for the tool to be able to read excel spreadsheets, xls and xlsx files, and read the date from the file and present it to the user. In this case, I was able to create an instance of a workbook and then tell it to read my xlsx file.
*For testing purposes, the file is hardcoded but users will be able to change the file location in the future.*
The program will then look at the first sheet, which is where the data lies in the xlsx file, and then loop through the first column and search each row in the column until it finds a match agains what the user searched for. If the tool can find the parameter that was searched for, it will then look to the next cell in that row and pull the information of what the parameter does and display it back to the user. This is done with getter and setter methods in the Search class. If the parameter is not found the response will be set to iparam not found.
With that, I also added the ability for users to be able to type in the value into the search box and either select the search button via the mouse or if the enter key is pressed, it will also search. This will help make the app more intuitive as most modern apps has this built in.
Next steps will be fine tuning the application to either add more features or refining the current ones to determine what is or is not needed and maybe some visual improvements as well.
Stay tuned!
Comments
Post a Comment