如何用Python统计excel每行出现的各颜色数量

Question

1.已有一个每行带颜色的工作表（用style.apply background color按条件生成）
现在想在每行统计各颜色的数量，比如红色绿色数量等
2.问题
start_color的方法在读取颜色时都是00000000，但实际上是颜色是肉眼可见的

Answer 1

from openpyxl import load_workbook

excel_file =  'score.xlsx'
wb = load_workbook(excel_file, data_only=True)
sh = wb['Sheet1']
# # this gives you Hexadecimal value of the color

for i in range(1, sh.max_row + 1):
    for j in range(1, sh.max_column + 1):
        print(f'row={i}', f'col={j}', f'color={sh.cell(i, j).fill.fgColor.rgb}', end = ' ')
    print()


'''--result
row=1 col=1 color=00000000 row=1 col=2 color=00000000 row=1 col=3 color=00000000 row=1 col=4 color=00000000 
row=2 col=1 color=00000000 row=2 col=2 color=FFFF0000 row=2 col=3 color=00000000 row=2 col=4 color=FFFF0000 
row=3 col=1 color=00000000 row=3 col=2 color=00000000 row=3 col=3 color=00000000 row=3 col=4 color=00000000 
'''