使用Python xlsxwriter向文本添加可变write_rich_string格式属性

import xlsxwriter

# 创建一个新的Excel文档
workbook = xlsxwriter.Workbook('output.xlsx')

# 创建一个工作表
worksheet = workbook.add_worksheet()

# 定义不同的格式
bold_format = workbook.add_format({'bold': True})
italic_format = workbook.add_format({'italic': True})
red_format = workbook.add_format({'color': 'red'})

# 定义要写入的字符串和对应的格式属性
text_with_formats = [
    ('This is ', None),
    ('bold', bold_format),
    (' and ', None),
    ('italic', italic_format),
    (' and ', None),
    ('red', red_format),
    (' text.', None)
]

# 使用write_rich_string方法向文本添加可变的格式属性
worksheet.write_rich_string('A1', *text_with_formats)

# 关闭Excel文档
workbook.close()