Openpyxl：我们发现某些内容有问题

使用Openpyxl库可以方便地处理Excel文件，但在实际使用过程中，我们可能会遇到一些问题。下面将介绍一些常见的问题以及解决方法，并附上相应的案例代码。

python
from openpyxl import load_workbook
filename = 'example.xlsx'
workbook = load_workbook(filename, read_only=True, keep_vba=False, data_only=True, keep_links=False)
# 在打开文件时指定编码方式
workbook.encoding = 'utf-8'
# 读取数据
worksheet = workbook.active
for row in worksheet.iter_rows(values_only=True):
    print(row)

python
from openpyxl import Workbook
workbook = Workbook()
worksheet = workbook.active
# 写入数据
data = ['Hello', 'World', 123]
for i, value in enumerate(data):
    worksheet.cell(row=1, column=i+1, value=str(value))
workbook.save('example.xlsx')

python
from openpyxl import load_workbook
from openpyxl.styles import Font, Color
filename = 'example.xlsx'
workbook = load_workbook(filename)
worksheet = workbook.active
# 修改数据
worksheet['A1'] = 'Hello'
worksheet['A1'].font = Font(color=Color(rgb="FF0000"))
# 重新应用样式
for row in worksheet.iter_rows():
    for cell in row:
        if cell.font:
            cell.font = Font(color=cell.font.color)
workbook.save('example.xlsx')