def GET(self): http = decorator.http() ssid = web.input(ssid=None).ssid try: cells = GoogleSpreadsheets.get_cells_from_first_worksheet(ssid, http=http) except: web.header('Content-Type', 'text/plain') raise return "bah" return render.spread(cells)
from apgooglelayer.spreadsheets import GoogleSpreadsheets secrets = "./client-secrets.json" service = get_service( secrets, ["https://www.googleapis.com/auth/drive", "https://spreadsheets.google.com/feeds"], "drive", "v2", "py4science-example05a", ) Drive = GoogleDrive(service) Spreadsheets = GoogleSpreadsheets() FileTree = Drive.folder_structure() i = 0 for name, treenode in FileTree.flatten_names(): if treenode.get("mimeType", "") == "application/vnd.google-apps.spreadsheet": i += 1 if i > 5: break print "Id:", treenode["id"] for j, cell in enumerate(Spreadsheets.get_cells_from_first_worksheet(treenode["id"], http=service._http)): if j >= 20: break print "%02d,%02d : %s" % (int(cell.cell.row), int(cell.cell.col), cell.content.text)