def write_all_excel(self,data1,data2):
excel_writer = pd.ExcelWriter("all_excel.xlsx", engine='openpyxl')
data1.to_excel(excel_writer, sheet_name="sheet1")
data2.to_excel(excel_writer, sheet_name="sheet2")
excel_writer.close()
# 图形写入excel
self.write_pic('bar_1.jpg','all_excel.xlsx','sheet1','I2')
self.write_pic('bar_2.jpg','all_excel.xlsx', 'sheet1', 'S2')
将多个dataframe同时利用to_excel写入excel里面多个sheet
最新推荐文章于 2024-07-20 03:44:21 发布