使用gspread创建的列表Google电子表格

问题描述：

我使用gspread创建了一些电子表格。使用gspread创建的列表Google电子表格

由于它们是使用Google服务密钥帐户创建的，因此我不知道如何访问它们。

如何查看使用特定服务密钥创建的所有电子表格？

你可以用'openall（）'这个：HTTP：//gspread.readthedocs。 IO/EN /最新/＃gspread.Client.openall – Burnash

答

终于找到了答案。

直接在gspread码看后，我发现这一点：https://github.com/burnash/gspread/blob/addd4940bf7e4f87aae598920facae2155e555b6/gspread/client.py#L151

所以此工程：

from oauth2client.service_account import ServiceAccountCredentials 
import gspread 
from gspread.ns import _ns 

# If modifying these scopes, delete your previously saved credentials 
# at ~/.credentials/sheets.googleapis.com-python-quickstart.json 
SCOPES = ['https://spreadsheets.google.com/feeds', 
      'https://www.googleapis.com/auth/drive'] 
CLIENT_SECRET_FILE = 'client_secret.json' 
APPLICATION_NAME = 'Google Sheets API Python' 


def get_credentials(): 
    """Gets valid user credentials from storage. 

    If nothing has been stored, or if the stored credentials are invalid, 
    the OAuth2 flow is completed to obtain the new credentials. 

    Returns: 
     Credentials, the obtained credential. 
    """ 

    return ServiceAccountCredentials.from_json_keyfile_name(CLIENT_SECRET_FILE, SCOPES) 

credentials = get_credentials() 
gc = gspread.authorize(credentials) 
feed = gc.get_spreadsheets_feed() 

for elem in feed.findall(_ns('entry')): 
    elem_title = elem.find(_ns('title')).text 
    print(elem_title)

使用gspread创建的列表Google电子表格

相关推荐