I am trying to access google spreadsheets through gspread api
in python. I have imported gspread
. I am getting socket. error: [Errno 10061] No connection could be made because the target machine actively refused it
at gc = gspread.login('pan*******@gmail.com', '********')
Here is my code:
import urllib2
import urllib
import gspread
from PIL import Image
from PIL import ImageDraw
from PIL import ImageFont
w = 420
gc = gspread.login('pan******@gmail.com', '*******')
wks = gc.open("Spreadsheet").sheet1
I have checked that the username and password is correct. I have added two environment variables as 'http_proxy':'host:port'
and 'https_proxy':'host:port'
What am I doing wrong?
Thank you.
For anyone who might have this problem, I found out that gspread library doesn't support proxy connections. I ran it through normal connection and it worked.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With