如何使用Python在Excel中将合计动态添加到行尾？

import openpyxl
from openpyxl.utils import get_column_letter
from openpyxl.styles import Font

def add_total_to_excel(file_path, sheet_name):
    # 打开Excel文件
    wb = openpyxl.load_workbook(file_path)
    # 选择工作表
    sheet = wb[sheet_name]
    
    # 获取最大行数和最大列数
    max_row = sheet.max_row
    max_column = sheet.max_column
    
    # 计算每列的合计值
    for col in range(1, max_column + 1):
        col_letter = get_column_letter(col)
        total_formula = f"SUM({col_letter}2:{col_letter}{max_row})"
        sheet[f"{col_letter}{max_row + 1}"] = total_formula
    
    # 设置合计行的字体样式
    for cell in sheet[max_row + 1]:
        cell.font = Font(bold=True)
    
    # 保存修改后的Excel文件
    wb.save(file_path)

pip install openpyxl