【Py】给已存在的Excel添加sheet

使用pandas

import pandas as pd
from openpyxl import load_workbook

df = pd.DataFrame([{'a':1}])
book = load_workbook("test.xlsx")

with pd.ExcelWriter("test.xlsx",engine="openpyxl") as writer:
     writer.book = book
     df.to_excel(writer, sheet_name="sheet3", header=True)
     df.to_excel(writer, sheet_name="sheet4", header=True)

使用openpyxl

import pandas as pd
from openpyxl import load_workbook
from openpyxl.utils.dataframe import dataframe_to_rows

df = pd.DataFrame([{'a':1}])
book = load_workbook('test.xlsx')
book.create_sheet('sheet3')
ws3 = book['sheet3']
for r in dataframe_to_rows(df, index=True, header=True):
	ws3.append(r)
book.save('test.xlsx')

参考：
https://stackoverflow.com/a/42375263/7151777
https://stackoverflow.com/a/40385840/7151777