准备数据：
求和代码：
import openpyxl
wb = openpyxl.load_workbook('C:/Users/Administrator/Desktop/1.xlsx')
ws = wb['test']
min_row = ws.min_row
max_row = ws.max_row
min_col = ws.min_column
max_col = ws.max_column
for row in range(min_row + 1, max_row + 1):
key = ws.cell(row=row, column=max_col).coordinate
# 求和的开始单元格地址
start = ws.cell(row=row, column=min_col + 1).coordinate
# 求和的结束单元格地址
end = ws.cell(row=row, column=max_col - 1).coordinate
ws[key] = f'=SUM({start}:{end})'
wb.save('公式插入.xlsx')
实现效果如下：
