import gdata.spreadsheet.service username = 'prakhil.purch...@gmail.com' passwd = 'purchase' doc_name = 'googleapps_spreadsheet' gd_client = gdata.spreadsheet.service.SpreadsheetsService() gd_client.email = username gd_client.password =passwd #gd_client.source = 'pythonsample12' gd_client.ProgrammaticLogin() q = gdata.spreadsheet.service.DocumentQuery() q['title'] = doc_name q['title-exact'] = 'true' feed = gd_client.GetSpreadsheetsFeed(query=q) spreadsheet_id = feed.entry[0].id.text.rsplit('/',1)[1] feed = gd_client.GetWorksheetsFeed(spreadsheet_id) worksheet_id = feed.entry[0].id.text.rsplit('/',1)[1] rows = gd_client.GetListFeed(spreadsheet_id, worksheet_id).entry for row in rows: for key in row.custom: print " %s: %s" % (key, row.custom[key].text)
This is the python code I was trying to access the cell information from a google spreadsheet but the issue is that i am able to make it work on Eclipse but when i deploy it, it is not showing me the result. Maybe I am missing some of the google packages to import that is making it unable to run on google environment. Kindly guide me.Thanks in advance. -- http://mail.python.org/mailman/listinfo/python-list