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.
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.