pandas向已有excel工作簿中追加新表，不覆盖原表

主体思想：利用openpyxl模块

import pandas as pd

from openpyxl import load_workbook

book = load_workbook('test.xlsx')

writer = pd.ExcelWriter('test.xlsx', engine='openpyxl')

writer.book = book

df1.to_excel(writer,'first')

writer.save()

结论：此方法向工作簿中追加原表不会覆盖原有表格

import pandas as pd

dataframe1=pd.DataFrame({'a':[1,2,3,4],'b':[5,6,7,8]})

dataframe2=pd.DataFrame({'a':[9,10,11,12],'b':[13,14,15,16]})

dataframe3=pd.DataFrame({'a':[17,18,19,20],'b':[21,22,23,24]})

writer = pd.ExcelWriter('result.xlsx')    #建立excel

mm= {'dataframe1':'sheet1','dataframe2':'sheet2','dataframe3':'sheet3'}     #构建字典

for i,a in mm.items():

       eval(i).to_excel(excel_writer=writer,sheet_name=str(a),index=False)

writer.save()

writer.close()

---