token.authorize(client) print print "Test #1: list all spreadsheets" sheets = client.get_spreadsheets() for entry in sheets.entry: sid = re.sub(r'.*\/', '', entry.get_id()) print "title:", entry.title.text print " url:", entry.get_id() print " id:", sid if entry.title.text == 'platform-gps-prjs-201408': prjs_sheet_id = sid print print "Test#2: list all worksheets in 'platform-gps-prjs-201408 (%s)'" % prjs_sheet_id worksheets = client.get_worksheets(prjs_sheet_id) for entry in worksheets.entry: wid = re.sub(r'.*\/', '', entry.get_id()) print "title:", entry.title.text print " url:", entry.get_id() print " id:", wid if entry.title.text == 'platform-gps-prjs-201407': prjs_worksheet_id = wid print print "Test#3: list some columns of raw #1 in 'platform-gps-prjs-201408'" row = 1 for column in range(1, 10): cell = client.get_cell(prjs_sheet_id, prjs_worksheet_id, 1, column) print " [%d, %d] %s" % (row, column, cell.content.text)
# -*- coding: utf-8 -*- from oauth2client.client import SignedJwtAssertionCredentials import gdata.spreadsheets.client # 認証に必要な情報 client_email = "*****@*****.**" # 手順2で発行されたメールアドレス with open("bigquery-python-ca3e147753fe.p12") as f: private_key = f.read() # 手順2で発行された秘密鍵 # 認証情報の作成 scope = ["https://spreadsheets.google.com/feeds"] credentials = SignedJwtAssertionCredentials(client_email, private_key, scope=scope) # スプレッドシート用クライアントの準備 client = gdata.spreadsheets.client.SpreadsheetsClient() # OAuth2.0での認証設定 auth_token = gdata.gauth.OAuth2TokenFromCredentials(credentials) auth_token.authorize(client) # ---- これでライブラリを利用してスプレッドシートにアクセスできる ---- # # ワークシートの取得 sheets = client.get_worksheets("1F5opPDJ5CaAZyGwZrlfUlc4dso3sQ6KBdKIIK6970SA") # スプレッドシートIDを指定 for sheet in sheets.entry: print sheet.get_worksheet_id() cell = client.get_cell("1F5opPDJ5CaAZyGwZrlfUlc4dso3sQ6KBdKIIK6970SA", "ontqp3p", 7, 2) print cell.__dict__ print cell.title
def get_cell_obj(client,sheet,page,r, c): return client.get_cell(spreadsheet_key,1,ROW,COL)