A couple of options are:
1) Save the Excel spreadsheet as a CSV and read/search it through standard Java APIs for file, string, and text manipulation
2) Take a look at the Apache/Jakarta POI APIs, in particular the HSSF project ( http://jakarta.apache.org/poi/hssf/how-to.html ). These classes will allow you to read a write Excel 97 formatted files.
Hope this helps.
On Wednesday, May 28, 2003, at 04:05 PM, Lance Prais wrote:
All I need to search a .xls file and am not sure how to approach it.
I have a document that is around 200 records with two columns I need to be able to search it using java to incorporate it into my JSP pages. I normally would do this in perl but it is not an option and am not that familiar with Java.
Any suggestions
Thanks in advanced
_______________________________________________________________________ ____ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
