代码如下:
import pandas as pd
writer = pd.ExcelWriter(‘your_path.xlsx’)
df1 = pd.DataFrame([1])
df2 = pd.DataFrame([2])
df1.to_excel(writer, sheet_name=‘df_1’)
df2.to_excel(writer, sheet_name=‘df_2’)
writer.save()
代码如下:
import pandas as pd
writer = pd.ExcelWriter(‘your_path.xlsx’)
df1 = pd.DataFrame([1])
df2 = pd.DataFrame([2])
df1.to_excel(writer, sheet_name=‘df_1’)
df2.to_excel(writer, sheet_name=‘df_2’)
writer.save()