先在需要的目录下创建xlsx文件
如data.xlsx
def write_excel(dataframe, excelWriter, sheetname):
"""
数据写入到Excel,可以写入不同的sheet
"""
book = load_workbook(excelWriter.path)
excelWriter.book = book
dataframe.to_excel(excel_writer=excelWriter, sheet_name=sheetname, index=None)
excelWriter.close()
excelPath = r'C:\Users\XXXX\XXXX\XXXX\data.xlsx'
excelWriter = pd.ExcelWriter(excelPath, engine='openpyxl')
write_excel(x_1, excelWriter, 'b')