XlsxWriter中以正/负值为条件的条形着色

import xlsxwriter

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

# 定义格式化条件
positive_format = workbook.add_format({'bg_color': '#C6EFCE', 'font_color': '#006100'})
negative_format = workbook.add_format({'bg_color': '#FFC7CE', 'font_color': '#9C0006'})

# 写入数据
data = [1, -2, 3, -4, 5]
for i, value in enumerate(data):
    worksheet.write(i, 0, value)

# 应用条件格式化
worksheet.conditional_format(0, 0, len(data)-1, 0, {'type': 'cell', 'criteria': '>', 'value': 0, 'format': positive_format})
worksheet.conditional_format(0, 0, len(data)-1, 0, {'type': 'cell', 'criteria': '<', 'value': 0, 'format': negative_format})

# 关闭Excel文件
workbook.close()