python使用Pandas生成多sheet的Excel文件
import pandas as pd
data0 = pd.DataFrame({'a': [1, 2, 3], 'b': [4, 5, 6]})
data1 = pd.DataFrame({'c': [1, 5, 9], 'd': [2, 5, 8]})
writer = pd.ExcelWriter('path.xls')
data0.to_excel(writer, sheet_name='名称0')
data1.to_excel(writer, sheet_name='名称1')
writer.save()
writer.close()
结果展示