Friday, February 17, 2012

Some more fun with Google spreadsheets

Import a table in an html page to a google spread sheet.
in a cell type:-=ImportHtml(”http://en.wikipedia.org/wiki/List_of_deserts_by_area", ”table”,1)
then press enter.we will see the whole table in the spreadsheet.
Import feeds in a spreadsheets
=ImportFeed("http://feeds.feedburner.com/InstantFundas")
=ImportFeed("http://pipes.yahoo.com/pipes/pipe.run?_id=8118acdb0e7a87efc7bdb788ed62e8a6&_render=rss")
Get all links on yahoo page
=importXml("www.yahoo.com", "//a/@href") 

No comments:

Post a Comment