xlsxwriter引擎下的条件格式

import xlsxwriter

# 创建一个新的Excel文件
workbook = xlsxwriter.Workbook('example.xlsx')
worksheet = workbook.add_worksheet()

# 创建条件格式的样式对象
format1 = workbook.add_format({'bg_color': 'red'})
format2 = workbook.add_format({'bg_color': 'green'})

# 设置条件格式
worksheet.conditional_format('A1:A10', {'type': 'cell',
                                         'criteria': '>=',
                                         'value': 5,
                                         'format': format1})
worksheet.conditional_format('A1:A10', {'type': 'cell',
                                         'criteria': '<',
                                         'value': 5,
                                         'format': format2})

# 写入数据
worksheet.write_column('A1', [1, 2, 3, 4, 5, 6, 7, 8, 9, 10])

# 关闭并保存Excel文件
workbook.close()