如何使用python动态设置excel表格的50列值？

pip install openpyxl

from openpyxl import Workbook, load_workbook

# 打开现有的Excel文件
workbook = load_workbook('filename.xlsx')

# 创建一个新的Excel文件
workbook = Workbook()

# 选择默认的工作表
sheet = workbook.active

# 选择指定名称的工作表
sheet = workbook['Sheet1']

for i in range(1, 51):
    column_letter = chr(64 + i)  # 将数字转换为对应的列字母
    cell = f'{column_letter}1'  # 构建单元格地址
    sheet[cell] = i  # 设置单元格的值

workbook.save('filename.xlsx')
workbook.close()