如何从我只能查看访问谷歌合作实验室的谷歌电子表格中获取数据

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

---

想要改进这个问题？通过编辑这篇文章添加详细信息并澄清问题。

2 年前已关闭。

Answer 1

您应该可以通过使用 gspread 在访问访问 中检索表格的内容。 。

示例：

测试表：

​

!pip install --upgrade -q gspread

import gspread
import pandas as pd
from google.colab import auth
from google.auth import default
auth.authenticate_user()
creds, _ = default()

gc = gspread.authorize(creds)
# sh = gc.open_by_url("Insert Sheet URL here")
sh = gc.open_by_key("Insert Sheet key here")
worksheet = sh.worksheet("Sheet1")
rows = worksheet.get_all_values()
pd.DataFrame.from_records(rows)

​

​ >

sstatic.net/vayvd.png“ rel =“ nofollow

• noreferrer ” a href =“ https://docs.gspread.org/en/latest/user-guide.html#opening-a-a-spreadsheet” rel =“ nofollow noreferrer”> gspread：打开电子表格