Screen scraping using Google Documents in a minute or less…

0 0

In a previous blog Lucas used JSoup to collect data from a web page. In this post I’ll show a declarative way to screen scrape data with the help of Google Documents.

The following webpage http://www.databaseolympics.com/games/gamesyear.htm?g=26 contains the olympic data I would like to import

1. Open a new Google spreadsheet document.
2. Paste the following formula in a cell A1
   =ImportHtml("http://www.databaseolympics.com/games/gamesyear.htm?g=26";"table"; 3)
3. Press enter 🙂

The importHtml function instructs Google Documents to retrieve the third table on the webpage. There are other import functions as well see http://docs.google.com/support/bin/answer.py?answer=75507 for more information.

About Post Author

Jorrit Nijssen

Jorrit is a senior Oracle consultant.

jorrit.nijssen@amis.nl

Happy

0 0 %

Sad

0 0 %

Excited

0 0 %

Sleepy

0 0 %

Angry

0 0 %

Surprise

0 0 %

Related posts:

SOA and Email in action – Starting a BPEL process instance by sending an email with XML content- on decoupled interaction between web-site and back office Advanced Javascript debugging with FireBug and analyzing your page with View Source Chart Javapolis 2006 – Building Sexy Web apps with Flex Using SoapUI on Apache ODE to test your BPEL processes more quickly Extending XML Document Validation with Schematron