更新时Gspread httperror

2024-10-03 21:36:02 发布

您现在位置:Python中文网/ 问答频道 /正文

出于某种原因,我得到:gspread.httpsession.HTTPError文件当尝试更新单元格时。你知道吗

spreadsheet_name = raw_input("Please enter a spreadsheet url: ")
json_keys = json.load(open('keys.json'))
scopes = ['https://spreadsheets.google.com/feeds']
credentialss = SignedJwtAssertionCredentials(json_keys['client_email'], 
json_keys['private_key'], scopes)
gcs = gspread.authorize(credentialss)
wkss = gcs.open_by_url(spreadsheet_name).sheet1

在一个函数中返回wkss 然后呢

time.sleep(3)
all_data = wkss.get_all_values()
row_track = 0
for rows in all_data:
    print str(row_track)
    for dd in data:
        if str(rows[5]) == str(dd[1]):
            pdb.set_trace()
            wkss.update_cell(row_track, 29, dd[2].strip())
            print str(row_track) + ", 24" 
            print "MATCH"
    row_track +=1

python gspread google spreadsheet keeping connection alive

我发现了,但是既然我是通过这种方式访问工作表,那么我应该在哪里包含标题呢?客户似乎不喜欢我这样做。你知道吗


Tags: namejsonurldatatrackopenkeysall