出于某种原因,我得到: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
我发现了,但是既然我是通过这种方式访问工作表,那么我应该在哪里包含标题呢?客户似乎不喜欢我这样做。你知道吗
目前没有回答
相关问题 更多 >
编程相关推荐