pandas多个DataFrame保存到excel不同sheet（ExcelWriter）

import pandas as pd
writer = pd.ExcelWriter("./测试.xlsx",engine='openpyxl')

df_table1.to_excel(writer,index=False,sheet_name='table1')
df_table2.to_excel(writer,index=False,sheet_name='table2')
df_table3.to_excel(writer,index=False,sheet_name='table3')
df_table4.to_excel(writer,index=False,sheet_name='table4')

writer.save()

最后一行一定不要忘记，路径写好就ok了