Python/base
writer = pd.ExcelWriter('path/xlsx') df1.to_excel(writer, 'sheetsname1') df2.to_excel(writer, 'sheetsname2') writer.save()