现在,处理谷歌电子表格有两种选择:
Google自己的python客户端库
广布:
Https://github.com/burnash/gspread
我两个都用过了,我会选择Gspend。谷歌的lib太过冗长了。
在gspend中获取单元格值非常简单:
- # connect
- c = gspread.Client(auth=('johndoe@gmail.com','pass'))
- c.login()
-
- # open your spreadsheet
- s = c.open('annual results')
- # and worksheet
- w = s.get_worksheet(0)
-
- # Finally get your value
- v = worksheet.cell(4, 2).value
-