1.向已有Excel,已有sheet中追加数据
2.向已有Excel,已有sheet中追加sheet
import openpyxl
import pandas as pd
wb = openpyxl.load_workbook(r'D:\PycharmProjects\Abaqus Reform\\输出的数据.xlsx')、
#要输出Excel的路径
writer = pd.ExcelWriter(r'D:\PycharmProjects\Abaqus Reform\\输出的数据.xlsx',engine='openpyxl')
writer.book = wb
df_empty.to_excel(writer, 'B点', float_format="%.5f", startrow=3, startcol=11, header=False,index=False)
#startrow=3, startcol=11,表示写入excel的位置
writer.save()
writer.close()
3.向excel中写入sheet
import openpyxl
import pandas as pd
#要输出Excel的路径
writer = pd.ExcelWriter(r'D:\PycharmProjects\Abaqus Reform\\输出的数据.xlsx',engine='openpyxl')
df_empty.to_excel(writer, 'B点', float_format="%.5f", startrow=3, startcol=11, header=False,index=False)
#startrow=3, startcol=11,表示写入excel的位置
writer.save()
writer.close()