如何使用python在excel中存储列的字符串

import pandas as pd
from openpyxl import Workbook, load_workbook

workbook = load_workbook('data.xlsx')
sheet = workbook.active
column = sheet['A']

strings = [cell.value for cell in column]

# 示例：将字符串转为大写
strings_upper = [string.upper() for string in strings]

# 写回到原始的Excel文件
for i, string in enumerate(strings_upper):
    column[i].value = string

# 或者创建新的Excel文件，并将数据写入
new_workbook = Workbook()
new_sheet = new_workbook.active
for i, string in enumerate(strings_upper):
    new_sheet.cell(row=i+1, column=1, value=string)
new_workbook.save('new_data.xlsx')