Posts

Showing posts from July, 2023

Iparam Finder Search Functionality

Image
 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 i...