excel写入多个sheet

import pandas as pd
from openpyxl import load_workbook
 
# padas dataframe生成excel
 
def df2sheet(dataframe, writer, sname):
   # DataFrame转换成excel中的sheet表
   dataframe.to_excel(excel_writer=writer, sheet_name=sname,index=None)
   writer.save()
   writer.close()

# excel中新增sheet表
def excelAddSheet(df, writer, sname):
   book = load_workbook(writer.path)
   writer.book = book
   df.to_excel(excel_writer=writer,sheet_name=sname,index=None)
   writer.close()

import matplotlib.pyplot as plt
excelPath = r"曲面.xlsx"
writer=pd.ExcelWriter(excelPath,engine='openpyxl')
plt.figure(figsize=(20, 10))
for i in range(2, data.shape[1]):
    dffA = data[['A量', 'A度']]
    dfA = data.iloc[:, i]
    dffA = pd.concat([dffA, dfA], axis=1)
    alist = cal_lxqm(dff