使用Python在列的多个单元格中包含公式的XLS

pip install openpyxl

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

# 创建一个新的工作簿
wb = Workbook()
# 选择默认的活动工作表
ws = wb.active

# 设置列标题
columns = ['A', 'B', 'C', 'D']
for col_num, column_title in enumerate(columns, 1):
    col_letter = get_column_letter(col_num)
    ws['{}1'.format(col_letter)] = column_title
    ws['{}1'.format(col_letter)].font = Font(bold=True)

# 设置数据
data = [
    [1, 2, 3, '=SUM(A2:C2)'],
    [4, 5, 6, '=SUM(A3:C3)'],
    [7, 8, 9, '=SUM(A4:C4)'],
]

for row_num, row_data in enumerate(data, 2):
    for col_num, cell_value in enumerate(row_data, 1):
        col_letter = get_column_letter(col_num)
        ws['{}{}'.format(col_letter, row_num)] = cell_value

# 保存工作簿
wb.save('example.xlsx')