Java code to search an excel spreasheet

[Mark Mitchell]

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?

Any help is greatly appreciated.

thanks,
Mark

[Paul Sturrock]

Careful Mark - you'll get a row for cross posting.

Anyway - as I said in your other post - don't use Java, use VBA.

[Mark Mitchell]

I apologize for that. I will continue my question in the JSP forum.

[Mark Mitchell]

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.

thanks

[Ken Januski]

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.

[Stan James]

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.

[Mark Mitchell]

Do you have an example of how to query a named range?

[Jeroen Wenting]

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.