I have an document that has over 500 data numbers in the file. If I search for the these numbers manually it will take too long. I would like to automate this process by, creating a list box that will store the numbers I want to perform the search, and the program will search for these numbers in the Excel document. Has anyone created a Java program to search for items in an Excel spreadsheet? Does this make sense?
I have to use JSP. So if there is any way to learn how to search an Excel spreasheet please, instead of using VBA please let me know. If there is something else I should do, like importing the excel data into notepad, for example, please let me know if this is possible and how to do it.
Though I've never had time to experiment with it I believe that the POI package allows you to manipulate a number of MS's formats, including excel. But I expect it will take a little work to figure out how to do it. I'd google for POI.