python处理excel问题

Question

如何用python将数据写入一个excel表的多个sheet

Answer 1

个人一般是用pandas，因为感觉比较方便

import pandas as pd

writer = pd.ExcelWriter('sample.xlsx')

data1.to_csv(writer, sheet_name = 'sheet1')  # 这里data类型均为pd.DataFrame
data2.to_csv(writer, sheet_name = 'sheet2')

writer.save()

writer.close()