解决pandas的to_excel方法写入数据被覆盖的问题

1.先用openpyxl 读取到了excel文件的数据，载入excel文件的内容到ExcelWriter中，使用ExcelWriter写入保存

import pandas as pd
from openpyxl import load_workbook
 
df = pd.DataFrame([66])
 
with pd.ExcelWriter(r'C:\Users\Administrator\Desktop\1.xlsx') as writer:
    book = load_workbook(r'C:\Users\Administrator\Desktop\1.xlsx')
    writer.book = book # 读取excel
    writer.sheets = dict((ws.title, ws) for ws in book.worksheets) # 复制excel的所有表
    df.to_excel(writer,startrow=0, startcol=0, index=False)

2.多文件写入

import pandas
from openpyxl import load_workbook


# 读取的文件
read_list = [r'C:\Users\Administrator\Desktop\1.xlsx',r'C:\Users\Administrator\Desktop\2.xlsx']
# 写入的文件
write_list = [r'C:\Users\Administrator\Desktop\3.xlsx']

write_file = write_list[0]
writer = pandas.ExcelWriter(write_file)


# 读取数据
def read_excel1(read_file):
    data = pandas.read_excel(read_file,header=None)
    return data


# 写入数据
def to_excel1(data,m):
    res = data
    
    with pd.ExcelWriter(write_list[0]) as writer:
        book = load_workbook(write_list[0])
        writer.book = book # 读取excel
        writer.sheets = dict((ws.title, ws) for ws in book.worksheets) # 复制excel的所有表
        res.to_excel(writer,startrow=1,sheet_name='Sheet1', startcol=m, index=False,header=None)


for i in range(8):
    read_flie1 = read_list[0]
    read_flie2 = read_list[1]
    res1 = read_excel1(read_flie1)
    res2 = read_excel1(read_flie2)
    data = res1.iloc[1:,i+1:i+2] - res2.iloc[1:,i+1:i+2]
    to_excel1(data,i+1)