python - gspread 到谷歌表 TimeoutError:[WinError 10060]
问题描述
连接尝试失败,因为连接方在一段时间后没有正确响应或连接的主机没有响应。
import gspread
from oauth2client.service_account import ServiceAccountCredentials
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
creds = ServiceAccountCredentials.from_json_keyfile_name('C:/Users/robin/Desktop/work/secret.json', scope)
client = gspread.authorize(creds)
sheet = client.open("python to sheets").sheet1
错误:
Traceback (most recent call last):
File "c:/Users/robin/Desktop/work/google.py", line 9, in <module>
client = gspread.authorize(creds)
File "C:\Python35\lib\site-packages\gspread\__init__.py", line 38, in authorize
client.login()
File "C:\Python35\lib\site-packages\gspread\client.py", line 51, in login
self.auth.refresh(http)
File "C:\Python35\lib\site-packages\oauth2client\client.py", line 545, in refresh
self._refresh(http)
File "C:\Python35\lib\site-packages\oauth2client\client.py", line 749, in _refresh
self._do_refresh_request(http)
File "C:\Python35\lib\site-packages\oauth2client\client.py", line 780, in _do_refresh_request
body=body, headers=headers)
File "C:\Python35\lib\site-packages\oauth2client\transport.py", line 282, in request
connection_type=connection_type)
File "C:\Python35\lib\site-packages\httplib2\__init__.py", line 1976, in request
cachekey,
File "C:\Python35\lib\site-packages\httplib2\__init__.py", line 1640, in _request
conn, request_uri, method, body, headers
File "C:\Python35\lib\site-packages\httplib2\__init__.py", line 1546, in _conn_request
conn.connect()
File "C:\Python35\lib\site-packages\httplib2\__init__.py", line 1384, in connect
raise socket_err
File "C:\Python35\lib\site-packages\httplib2\__init__.py", line 1317, in connect
sock.connect((self.host, self.port))
TimeoutError: [WinError 10060]
解决方案
推荐阅读
- laravel - Facebook 页面 iFrame 在 Boostrap 模板中显示问题,同时使用 Laravel 作为后端发送 iframe 代码
- asp.net - 在 DetailsView 中数据库绑定 DropdownList 的第一个索引处添加项目
- r - 年-月-日格式的日期之间的差异
- excel - Vba 宏在家用电脑上运行,在工作电脑上出现错误 2147417848
- php - 使用 laravel 在全站范围内查找密集查询/页面
- spring - 两个实体之间的共享主键不起作用
- java - Java – 正则表达式 – 匹配开始和结束卷曲标签
- html - 使用 flex-start 和 flex-end 将图标固定到 flexbox 容器的角落
- javascript - 交换两个变量值的哪种方式更优化?
- python - 单击提交按钮时使用for循环无法获取文本框的所有值