Excel文件多张表分批写入操作

Excel文件多张表分批写入操作

writer = pd.ExcelWriter(path)

data1.to_excel(excel_writer=writer, sheet_name=sheet1, na_rep=0, float_format="%.2f", encoding=‘UTF-8’, index=False)

data2.to_excel(excel_writer=writer, sheet_name=sheet1, na_rep=0, float_format="%.2f", encoding=‘UTF-8’, index=False)
。。。。

writer.save()
writer.close()