提到在Google Sheet中插入Pandas Dataframe的单元格

import pandas as pd
import gspread
from oauth2client.service_account import ServiceAccountCredentials

# 替换为你保存的Google Cloud凭证文件路径
credentials = ServiceAccountCredentials.from_json_keyfile_name('path/to/credentials.json', ['https://www.googleapis.com/auth/spreadsheets'])
client = gspread.authorize(credentials)

# 假设你有一个名为df的Pandas DataFrame
df = pd.DataFrame({'Column1': [1, 2, 3], 'Column2': ['A', 'B', 'C']})

# 替换为你的Google Sheet文件名和工作表名称
sheet_name = 'Your Sheet Name'
worksheet_name = 'Your Worksheet Name'

# 打开Google Sheet文件和工作表
sheet = client.open(sheet_name)
worksheet = sheet.worksheet(worksheet_name)

# 获取Pandas DataFrame的数据列表
data = df.values.tolist()

# 获取数据范围
range = worksheet.range(f'A1:B{len(data)+1}')  # 假设数据从A1开始

# 更新单元格的值
for i, cell in enumerate(range):
    cell.value = data[i]

# 批量更新单元格的值
worksheet.update_cells(range)