Advanced Search

Return to Snippet

Revision: 35660
at November 11, 2010 21:17 by vetri02
Initial Code 
import urllib2
from BeautifulSoup import BeautifulSoup

page = urllib2.urlopen("https://spreadsheets.google.com/pub?key=0AujzeBNXnyI-dDNBRFJZaTZyRnZnMzdnQlFzSkRsd2c&hl=en&output=html")

soup = BeautifulSoup(page)
ted = soup.findAll('td',{ 'class' : 's1'})
for td in ted:
  print td.string
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Create a spreadsheet on google doc share it and publish as web page ,take the url and put it instead of the URL pasted here on the code.You can retrieve the column values accordingly by changing the class name on soup.findAll (eg.:'class' : 's1')

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Retreive data from google spreadsheet using python and beautiful soup

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
Python