Bookmark Topic Watch Topic
  • New Topic

Search an excel spreasheet  RSS feed

 
Mark Mitchell
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Report post to moderator
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 JSP page/program to search for items in an Excel spreadsheet? Does this make sense?
Any help is greatly appreciated.

Thanks,
Mark
[ June 14, 2004: Message edited by: Mark Mitchell ]
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Report post to moderator
Far easier is creating a script in VBA to do this, since to do it in Java requires JNI programming or a java-COM bridge. Excel isn't really designed to act as a data repository for web apps like this either.
[ June 14, 2004: Message edited by: Paul Sturrock ]
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 65833
134
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Report post to moderator
Do not cross-post the same question in multiple forums. Continue any discussion here.
 
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!