多个dataframe怎样to_excel到不同的sheet里？

Question

df1要to_excel到excel_file的sheet1，df2要to_excel到excel_file的sheet2
怎么实现呢？

Answer 1

writer = pd.ExcelWriter('a.xlsx')
df1.to_excel(writer, sheet_name='sheet1')
df2.to_excel(writer, sheet_name='sheet2')
writer.save()