使用pd.ExcelWriter writer=pd.ExcelWriter(r'C:\Users\s\Desktop\output.xlsx') data.to_excel(writer,sheet_name='sheet1',index=False) data2.to_excel(writer,sheet_name='sheet2',index=False) writer.save()