openpyxl对excel报表进行基本操作（六）

基本说明

设置excel图标集

from openpyxl import Workbook
from openpyxl.formatting.rule import IconSetRule, ColorScaleRule

wb = Workbook()
ws = wb.active

data = [    [40, 34],
    [20, 64],
    [30, 24],
    [60, 74],
    [70, 94],
    [80, 66],
]

for d in data:
    ws.append(d)

# 3Flags:3色旗  3Arrows：3色箭头  percent：指明不同条件的类型  showValue:是否展示图表对应的值，False表示不展示  reverse表示是否对图标进行反转
rule1 = IconSetRule('3Flags', 'percent', [0, 30, 50], showValue=True, reverse=False)
rule2 = IconSetRule('3Arrows', 'percent', [0, 30, 50], showValue=False, reverse=True)   

ws.conditional_formatting.add("A1:A4", rule1)
ws.conditional_formatting.add("B1:B4", rule2)

wb.save('test.xlsx')

保存结果如下：