#一个excel工作表中保存多个工作簿
from openpyxl import Workbook
from openpyxl import load_workbook
wb = Workbook() # 创建工作表
wb.save("产业生态.xlsx")
book = load_workbook("产业生态.xlsx")
writer = pd.ExcelWriter("产业生态.xlsx", engine='openpyxl')
writer.book = book
cystdata2.to_excel(writer, f"产业生态{nian}", index=False)
writer.save()