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.
You should be able to query an Excel range with JDBC/ODBC bridge. Set up an ODBC pointer to the Excel file, create a named range, treat that range as a table.
A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
Better yet, do the search inside the Excel file using a VBA module which you call using a Java-ActiveX bridge.
Then use that bridge from a Javabean which you call from a servlet which populates the data you display in the JSP. That's a proper architecture, separating business logic from display logic.
