python小技巧-使用pandas对excel表在同一个sheet里追加储存数据

• 实现效果
• 代码

import pandas as pd
from openpyxl import load_workbook

writer = pd.ExcelWriter(r'C:UsersSUNGUOQIANGDesktopexcel_save_test.xlsx',engine='openpyxl')
book=load_workbook(r'C:UsersSUNGUOQIANGDesktopexcel_save_test.xlsx')
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

row=1
for i in range(1,5):
    for j in range(1,5):
        row+=1
        a=i+j
        pd.Dataframe([a]).T.to_excel(writer, sheet_name='sheet1',startrow=row, index=False, header=False)
        writer.save()

注意：一定要加上writer.sheets = dict((ws.title, ws) for ws in book.worksheets)这句，读取已经存在的sheet，不然就会给你新建一个sheet存储。