如何使用Python将粗体样式应用于Excel文件中的特定单词？

import openpyxl

def bold_words(filename, words_to_bold):
    wb = openpyxl.load_workbook(filename, data_only=True)
    sheet = wb['Your_worksheet_name']

    for idx, row in enumerate(sheet.iter_rows(min_row=0, max_row=1, min_col=0, max_col=None, value_filter=None)):
        cols = len(row)
        for col in range(cols):
            cell = row[col]
            value = cell.value.strip()
            if value.lower() in words_to_bold:
                cell.font.bold = True
        yield idx

# 使用时，将 filename 替换为你需要处理的工作簿名称，将 'Your_worksheet_name' 替换成你要应用样式的表格的列名称：
with openpyxl.load_workbook('your_workbook.xlsx', data_only=True) as wb:
    for idx in bold_words('your_workbook.xlsx', 'your_words_to_bold'):
        del wb['Your_worksheet_name'][idx]

python bold_words.py  your_workbook.xlsx your_worksheet_name