python处理excel问题

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

个人一般是用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()

考虑看看 openpyxl

writer = pd.ExcelWriter(r'C:\Users\Administrator\Desktop\data_excel.xlsx')
for i in ['data1','data2','data3','data4']: #这里面存放变量
       eval(i).to_excel(excel_writer=writer,sheet_name=i,index=False)
writer.save()