Conditional Formatting 条件格式
ColorScale 色阶
语法
ColorScaleRule(start_type=None, start_value=None, start_color=None, mid_type=None, mid_value=None, mid_color=None, end_type=None, end_value=None, end_color=None)
type的值有
- num 数字
- percent 百分比
- max 最大
- min 最小
- formula 公式
- percentile 百分点数值
色阶有双色色阶以及三色色阶,如果是双色的话就没有mid_type等参数
实例
import openpyxl
from openpyxl.formatting.rule import ColorScaleRule
wb = openpyxl.load_workbook('/Users/junliangchen/Desktop/data.xlsx')
ws = wb.active
rule = ColorScaleRule(start_type='percent',start_value=30,start_color='FC556C', # 红
mid_type='percent',mid_value=60,mid_color='E5E500', # 黄
end_type='percent',end_value=90,end_color='1BA135') # 绿
ws.conditional_formatting.add('A2:A9',rule) # 将设置好的规则添加到工作表的条件格式中
wb.save('/Users/junliangchen/Desktop/data.xlsx')
IconSet 图标集
语法
IconSetRule(icon_style=None, type=None, values=None, showValue=None, percent=None, reverse=None)
参数详解
- icon_style:图标的样式
'3Arrows', '3ArrowsGray', '3Flags', '3TrafficLights1',
'3TrafficLights2', '3Signs', '3Symbols', '3Symbols2',
'4Arrows', '4ArrowsGray', '4RedToBlack', '4Rating',
'4TrafficLights', '5Arrows', '5ArrowsGray', '5Rating', '5Quarters'
- type同上
- showValue:bool值,是否显示值
- reverse:bool值,
实例
import openpyxl
from openpyxl