如何将python输出导出为GoogleSheets或Excel Doc？(页码优先)

pip install gspread openpyxl

import gspread
from oauth2client.service_account import ServiceAccountCredentials

# 身份验证
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
credentials = ServiceAccountCredentials.from_json_keyfile_name('path/to/service_account_key.json', scope)
client = gspread.authorize(credentials)

# 打开Google Sheets文档
doc = client.open('Google Sheets文档名称')

# 选择工作表
worksheet = doc.get_worksheet(0)  # 通过索引选择工作表，索引从0开始

# 写入数据
worksheet.update('A1', 'Hello, World!')

from openpyxl import Workbook

# 创建一个新的Excel Doc
wb = Workbook()

# 选择默认的工作表
ws = wb.active

# 写入数据
ws['A1'] = 'Hello, World!'

# 保存Excel Doc
wb.save('path/to/excel_doc.xlsx')

pip install pandas

import pandas as pd

# 创建一个DataFrame对象
data = {'Column1': [1, 2, 3, 4, 5],
        'Column2': ['A', 'B', 'C', 'D', 'E']}
df = pd.DataFrame(data)

# 导出为Google Sheets
df.to_csv('path/to/google_sheets.csv', index=False)

# 导出为Excel Doc
df.to_excel('path/to/excel_doc.xlsx', index=False)