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)
