File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes automate web data lookup Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "automate web data lookup" Watch "automate web data lookup" New topic

automate web data lookup

Julia Reynolds
Ranch Hand

Joined: May 31, 2001
Posts: 123

My shop needs to automate a manual process that involves looking up keys in an Excel spreadsheet by entering them in a search form on the web, then pasting the resulting values back into the spreadsheet.

Generally speaking, I was thinking of importing the spreadsheet into the db and writing a simple servlet to loop over the key data, do a post to the search page, parse out the desired value, and insert the value back into the database.

Have any of you cowpokes done this before? If so, I am eager to hear sage advice from all.


William Brogden
Author and all-around good cowpoke

Joined: Mar 22, 2000
Posts: 13036
Well, I dunno about the DB part, but you may find the Apache Commons HttpClient toolkit handy for the web lookup part.
Julia Reynolds
Ranch Hand

Joined: May 31, 2001
Posts: 123

Thanks for the tip about httpclient. It worked like a charm and the solution is going to be quick and easy.

I agree. Here's the link:
subject: automate web data lookup
It's not a secret anymore!