如何在Python中对Excel混合字符集的字符串进行编码

from openpyxl import load_workbook

# 加载Excel文件
workbook = load_workbook('example.xlsx')

# 选择要处理的工作表
worksheet = workbook['Sheet1']

# 遍历单元格，获取需要编码的字符串
for row in worksheet.iter_rows():
    for cell in row:
        if isinstance(cell.value, str):
            # 对字符串进行编码操作
            encoded_string = cell.value.encode('utf-8')
            # 更新单元格的值为编码后的字符串
            cell.value = encoded_string

# 保存修改后的Excel文件
workbook.save('example_encoded.xlsx')