如何使用openpyxl将已读取的数据写入某一列

import openpyxl

workbook = openpyxl.load_workbook('filename.xlsx')

worksheet = workbook['Sheet1']  # 根据工作表名称选择
# 或者
worksheet = workbook.worksheets[0]  # 根据索引选择，索引从0开始

worksheet.cell(row=1, column=1).value = 'Data 1'  # 写入第1行第1列
worksheet.cell(row=2, column=1).value = 'Data 2'  # 写入第2行第1列

workbook.save('filename.xlsx')

import openpyxl

# 打开Excel文件
workbook = openpyxl.load_workbook('filename.xlsx')

# 选择工作表
worksheet = workbook['Sheet1']

# 写入数据
worksheet.cell(row=1, column=1).value = 'Data 1'
worksheet.cell(row=2, column=1).value = 'Data 2'

# 保存文件
workbook.save('filename.xlsx')