新建excel表格,并向指定sheet中保存数据,并不覆盖原有数据
from openpyxl import load_workbook
import pandas as pd
from openpyxl.chart import LineChart,Reference
target_file=pd.Dataframe()
target_file.to_excel('target.xlsx')
sheet_names=['A','B','C']
#创建3个sheet
for sheet_name in sheet_names:
writer=pd.ExcelWriter('target.xlsx',engine='openpyxl')
book=load_workbook('target.xlsx')
writer.book=book
df.to_excel(writer