This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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: 13001
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: automate web data lookup
It's not a secret anymore!