Python脚本导出Excel到Google工作表

Question

我想导出本地excel数据到谷歌表。我得到了所有api和需求。现在，我试着打开这个链接中的python脚本https://blog.coupler.io/python-to-google-sheets/#:~:text=append()-，Python%20script%20to%20export%20Excel%20to%20Google%20Sheets，-Already%20have%20an

def export_excel_to_sheets():
spreadsheet_id = '1JCEHwIa4ZzwAiKGmAnWGfbjeVCH_tWZF6MkIU0zICwM'
excel_data_df = pandas.read_excel('sample-excel.xlsx', sheet_name='Sheet1', skiprows = range(1, 62), engine='openpyxl')
excel_data_df['Date'] = excel_data_df['Date'].astype(str)
excel_data_df['Unnamed: 0'] = ''
body = {
'values': excel_data_df.values.tolist()
}


spreadsheet_service.spreadsheets().values().append(
spreadsheetId=spreadsheet_id, body=body, valueInputOption='USER_ENTERED', range='Sheet1').execute()
print('{0} cells appended.'.format(result 
.get('updates') 
.get('updatedCells')))
export_excel_to_sheets()

我有70行数据，我想把它们导出到谷歌表格。我不想"跳过"任何带有';skiprows = range(1,62) ';所以我删除或减少这个值。当我删除这些代码时，脚本得到一个HTTP400错误。

excel_data_df = pandas.read_excel('example.xlsx', sheet_name='Sheet1', skiprows = range(1, 62), engine='openpyxl')

删除" skiproww "代码，得到一个HttpError 400.

googleapiclient.errors.HttpError: <HttpError 400 when requesting https://sheets.googleapis.com/v4/spreadsheets/1VIWNRrBF3E9KQo_nT7ZXvT4qQYWymITAFLx2rDEGSPw/values/Sheet1:append?valueInputOption=USER_ENTERED&alt=json returned "Invalid JSON payload received. Unexpected token.
api/v1/users/home", NaN, "{ 'Content-Typ
^">

我想导出所有的数据到谷歌表没有问题。你的建议是什么?谢谢你。

Answer 1

我认为下面的答案会解决你的问题，请尝试一下。如果不起作用，请告诉我。https://github.com/burnash/gspread/issues/680 issuecomment - 561936295