在调整Excel单元格格式时,对颜色编码进行了整理,分享给大家!
根据已有的HEX格式,填充对应的颜色能够更加的直观体现。
import openpyxl
from openpyxl.styles import PatternFill,Color
color_path = r'十六进制颜色编码表.xlsx'
wb = openpyxl.load_workbook(color_path)
ws = wb.active
cell_range = ws["F2:F136"]
for row in cell_range:
for cell in row:
# 定义填充样式
pattern_fill = PatternFill(patternType='solid', fgColor=Color(rgb=cell.value))
cell.fill = pattern_fill
wb.save(color_path)
wb.close()
结果呈现:
序号 | 英文代码 | 形像颜色 | HEX格式 | RGB格式 | 对应颜色 |
---|---|---|---|---|---|
1 | White | 纯白 | #FFFFFF | 255,255,255 | FFFFFF |
2 | Ivory | 象牙色 | #FFFFF0 | 255,255,240 | FFFFF0 |
3 | LightYellow | 浅黄色 | #FFFFE0 | 255,255,224 | FFFFE0 |
4 | LemonYellow | 柠檬黄 | #FFFF00 | 255,255,0 | FFFF00 |
5 | Yellow | 黄色 | #FFFF00 | 255,255,0 | FFFF00 |
6 | Snow | 雪 | #FFFAFA | 255,250,250 | FFFAFA |
7 | FloralWhite | 花的白色 | #FFFAF0 | 255,250,240 | FFFAF0 |
8 | LemonChiffon | 柠檬薄纱 | #FFFACD | 255,250,205 | FFFACD |
9 | Cornislk | 玉米色 | #FFF8DC | 255,248,220 | FFF8DC |
10 | SeaShell | 海贝壳 | #FFF5EE | 255,245,238 | FFF5EE |
11 | LavenderBlush | 偏红的淡紫色 | #FFF0F5 | 255,240,245 | FFF0F5 |
12 | PapayaWhip | 番木瓜 | #FFEFD5 | 255,239,213 | FFEFD5 |
13 | BlanchedAlmond | 漂白的杏仁 | #FFEBCD | 255,235,205 | FFEBCD |
14 | MistyRose | 薄雾玫瑰 | #FFE4E1 | 255,228,225 | FFE4E1 |
15 | Bisque | (浓汤)乳脂,番茄等 | #FFE4C4 | 255,228,196 | FFE4C4 |
16 | Moccasin | 鹿皮鞋 | #FFE4B5 | 255,228,181 | FFE4B5 |
17 | NavajoWhite | Navajo白 | #FFDEAD | 255,222,173 | FFDEAD |
18 | PeachPuff | 桃色 | #FFDAB9 | 255,218,185 | FFDAB9 |
19 | Gold | 金 | #FFD700 | 255,215,0 | FFD700 |
20 | Pink | 粉红 | #FFC0CB | 255,192,203 | FFC0CB |
21 | LightPink | 浅粉色 | #FFB6C1 | 255,182,193 | FFB6C1 |
22 | Orange | 橙色 | #FFA500 | 255,165,0 | FFA500 |
23 | LightSalmon | 浅鲜肉(鲑鱼)色 | #FFA07A | 255,160,122 | FFA07A |
24 | DarkOrange | 深橙色 | #FF8C00 | 255,140,0 | FF8C00 |
25 | Coral | 珊瑚 | #FF7F50 | 255,127,80 | FF7F50 |
26 | HotPink | 热情的粉红 | #FF69B4 | 255,105,180 | FF69B4 |
27 | Tomato | 番茄 | #FF6347 | 255,99,71 | FF6347 |
28 | OrangeRed | 橙红色 | #FF4500 | 255,69,0 | FF4500 |
29 | DeepPink | 深粉色 | #FF1493 | 255,20,147 | FF1493 |
30 | BrightPurple | 亮紫色 | #FF00FF | 255,0,255 | FF00FF |
31 | PurePurple | 纯紫 | #FF00FF | 255,0,255 | FF00FF |
32 | Red | 纯红 | #FF0000 | 255,0,0 | FF0000 |
33 | OldLace | 老饰带 | #FDF5E6 | 253,245,230 | FDF5E6 |
34 | LightGoldenrodYellow | 浅秋麒麟黄 | #FAFAD2 | 250,250,210 | FAFAD2 |
35 | Linen | 亚麻布 | #FAF0E6 | 250,240,230 | FAF0E6 |
36 | AntiqueWhite | 古代的白色 | #FAEBD7 | 250,235,215 | FAEBD7 |
37 | Salmon | 鲜肉(鲑鱼)色 | #FA8072 | 250,128,114 | FA8072 |
38 | GhostWhite | 幽灵的白色 | #F8F8FF | 248,248,255 | F8F8FF |
39 | MediumSpringGreen | 适中的春天的绿色 | #F5FFFA | 245,255,250 | F5FFFA |
40 | WhiteSmoke | 白烟 | #F5F5F5 | 245,245,245 | F5F5F5 |
41 | Wheat | 小麦色 | #F5DEB3 | 245,222,179 | F5DEB3 |
42 | SandyBrown | 沙棕色 | #F4A460 | 244,164,96 | F4A460 |
43 | Azure | 蔚蓝色 | #F0FFFF | 240,255,255 | F0FFFF |
44 | Honeydew | 蜂蜜 | #F0FFF0 | 240,255,0 | F0FFF0 |
45 | AliceBlue | 爱丽丝蓝 | #F0F8FF | 240,248,255 | F0F8FF |
46 | Khaki | 卡其布 | #F0E68C | 240,230,140 | F0E68C |
47 | LightCoral | 淡珊瑚色 | #F08080 | 240,128,128 | F08080 |
48 | PaleGodenrod | 灰秋麒麟 | #EEE8AA | 238,232,170 | EEE8AA |
49 | Violet | 紫罗兰 | #EE82EE | 238,130,238 | EE82EE |
50 | DarkSalmon | 深鲜肉(鲑鱼)色 | #E9967A | 233,150,122 | E9967A |
51 | Lavender | 薰衣草花的淡紫色 | #E6E6FA | 230,230,250 | E6E6FA |
52 | LightCyan | 淡青色 | #E1FFFF | 225,255,255 | E1FFFF |
53 | BrulyWood | 结实的树 | #DEB887 | 222,184,135 | DEB887 |
54 | plum | 李子 | #DDA0DD | 221,160,221 | DDA0DD |
55 | Gainsboro | Gainsboro | #DCDCDC | 220,220,220 | DCDCDC |
56 | Crimson | 猩红 | #DC143C | 220,20,60 | DC143C |
57 | PaleVioletRed | 苍白的紫罗兰红色 | #DB7093 | 219,112,147 | DB7093 |
58 | GoldEnrod | 秋麒麟 | #DAA520 | 218,165,32 | DAA520 |
59 | Orchid | 兰花的紫色 | #DA70D6 | 218,112,214 | DA70D6 |
60 | Thistle | 蓟 | #D8BFD8 | 216,191,216 | D8BFD8 |
61 | LightGray | 浅灰色 | #D3D3D3 | 211,211,211 | D3D3D3 |
62 | Tan | 晒黑 | #D2B48C | 210,180,140 | D2B48C |
63 | Chocolate | 巧克力 | #D2691E | 210,105,30 | D2691E |
64 | Peru | 秘鲁 | #CD853F | 205,133,63 | CD853F |
65 | IndianRed | 印度红 | #CD5C5C | 205,92,92 | CD5C5C |
66 | MediumVioletRed | 适中的紫罗兰红色 | #C71585 | 199,21,133 | C71585 |
67 | Silver | 银白色 | #C0C0C0 | 192,192,192 | C0C0C0 |
68 | DarkKhaki | 深卡其布 | #BDB76B | 189,183,107 | BDB76B |
69 | RosyBrown | 玫瑰棕色 | #BC8F8F | 188,143,143 | BC8F8F |
70 | MediumOrchid | 适中的兰花紫 | #BA55D3 | 186,85,211 | BA55D3 |
71 | FireBrick | 耐火砖 | #B22222 | 178,34,34 | B22222 |
72 | PowDerBlue | 火药蓝 | #B0E0E6 | 176,224,230 | B0E0E6 |
73 | LightSteelBlue | 淡钢蓝 | #B0C4DE | 176,196,222 | B0C4DE |
74 | PaleTurquoise | 苍白的绿宝石 | #AFEEEE | 175,238,238 | AFEEEE |
75 | GreenYellow | 绿黄色 | #ADFF2F | 173,255,47 | ADFF2F |
76 | LightBLue | 淡蓝 | #ADD8E6 | 173,216,230 | ADD8E6 |
77 | DarkGray | 深灰色 | #A9A9A9 | 169,169,169 | A9A9A9 |
78 | Brown | 棕色 | #A52A2A | 165,42,42 | A52A2A |
79 | Sienna | 黄土赭色 | #A0522D | 160,82,45 | A0522D |
80 | DarkOrchid | 深兰花紫 | #9932CC | 153,50,204 | 9932CC |
81 | PaleGreen | 苍白的绿色 | #98FB98 | 152,251,152 | 98FB98 |
82 | DarkVoilet | 深蓝紫色 | #9400D3 | 148,0,211 | 9400D3 |
83 | MediumPurple | 适中的蓝紫色 | #9370DB | 147,112,219 | 9370DB |
84 | LightGreen | 淡绿色 | #90EE90 | 144,238,144 | 90EE90 |
85 | DarkSeaGreen | 深海洋绿 | #8FBC8F | 143,188,143 | 8FBC8F |
86 | SaddleBrown | 马鞍棕色 | #8B4513 | 139,69,19 | 8B4513 |
87 | DarkPurple | 深紫色 | #8B008B | 139,0,139 | 8B008B |
88 | DarkRed | 深红色 | #8B0000 | 139,0,0 | 8B0000 |
89 | BlueViolet | 深紫罗兰的蓝色 | #8A2BE2 | 138,43,226 | 8A2BE2 |
90 | LightSkyBlue | 淡蓝色 | #87CEFA | 135,206,250 | 87CEFA |
91 | SkyBlue | 天蓝色 | #87CEEB | 135,206,235 | 87CEEB |
92 | Gray | 灰色 | #808080 | 128,128,128 | 808080 |
93 | Olive | 橄榄绿 | #808000 | 128,128,0 | 808000 |
94 | Purple | 紫色 | #800080 | 128,0,128 | 800080 |
95 | Maroon | 栗色 | #800000 | 128,0,0 | 800000 |
96 | BabyGreen | 绿玉 | #7FFFAA | 127,255,170 | 7FFFAA |
97 | Chartreuse | 查特酒绿 | #7FFF00 | 127,255,0 | 7FFF00 |
98 | LawnGreen | 草坪绿 | #7CFC00 | 124,252,0 | 7CFC00 |
99 | MediumSlateBlue | 适中的板岩暗蓝灰色 | #7B68EE | 123,104,238 | 7B68EE |
100 | LightSlateGray | 浅石板灰 | #778899 | 119,136,153 | 778899 |
101 | SlateGray | 石板灰 | #708090 | 112,128,144 | 708090 |
102 | Beige | 米色(浅褐色) | #6B8E23 | 107,142,35 | 6B8E23 |
103 | SlateBlue | 板岩暗蓝灰色 | #6A5ACD | 106,90,205 | 6A5ACD |
104 | DimGray | 暗淡的灰色 | #696969 | 105,105,105 | 696969 |
105 | CornflowerBlue | 矢车菊的蓝色 | #6495ED | 100,149,237 | 6495ED |
106 | CadetBlue | 军校蓝 | #5F9EA0 | 95,158,160 | 5F9EA0 |
107 | OliveDrab | 橄榄土褐色(褐绿色) | #556B2F | 85,107,47 | 556B2F |
108 | Indigo | 靛青 | #4B0082 | 75,0,130 | 4B0082 |
109 | MediumTurquoise | 适中的绿宝石 | #48D1CC | 72,209,204 | 48D1CC |
110 | DarkSlateBlue | 深岩暗蓝灰色 | #483D8B | 72,61,139 | 483D8B |
111 | SteelBlue | 钢蓝 | #4682B4 | 70,130,180 | 4682B4 |
112 | RoyalBlue | 宝蓝 | #4169E1 | 65,105,225 | 4169E1 |
113 | Turquoise | 绿宝石 | #40E0D0 | 64,224,208 | 40E0D0 |
114 | SpringGreen | 春天的绿色 | #3CB371 | 60,179,113 | 3CB371 |
115 | LimeGreen | 酸橙绿 | #32CD32 | 50,205,50 | 32CD32 |
116 | DarkSlateGray | 深石板灰 | #2F4F4F | 47,79,79 | 2F4F4F |
117 | SeaGreen | 海洋绿 | #2E8B57 | 46,139,87 | 2E8B57 |
118 | ForestGreen | 森林绿 | #228B22 | 34,139,34 | 228B22 |
119 | LightSeaGreen | 浅海洋绿 | #20B2AA | 32,178,170 | 20B2AA |
120 | DodgerBlue | 道奇蓝 | #1E90FF | 30,144,255 | 1E90FF |
121 | MidnightBlue | 午夜的蓝色 | #191970 | 25,25,112 | 191970 |
122 | Aqua,Cyan | 水绿色,青色 | #00FFFF | 0,255,255 | 00FFFF |
123 | MintCream | 薄荷奶油 | #00FF7F | 0,255,127 | 00FF7F |
124 | Green | 绿色 | #00FF00 | 0,255,0 | 00FF00 |
125 | MediumAquamarine | 适中的碧绿色 | #00FA9A | 0,250,154 | 00FA9A |
126 | DarkTurquoise | 深绿宝石 | #00CED1 | 0,206,209 | 00CED1 |
127 | DeepSkyBlue | 深天蓝 | #00BFFF | 0,191,255 | 00BFFF |
128 | DarkCyan | 深青色 | #008B8B | 0,139,139 | 008B8B |
129 | Teal | 水鸭色 | #008080 | 0,128,128 | 008080 |
130 | DarkGreen | 深绿色 | #006400 | 0,100,0 | 006400 |
131 | Blue | 蓝色 | #0000FF | 0,0,255 | 0000FF |
132 | MediumBlue | 适中的蓝色 | #0000CD | 0,0,205 | 0000CD |
133 | DarkBlue | 深蓝色 | #00008B | 0,0,139 | 00008B |
134 | Navy | 海军蓝,深靛蓝 | #000080 | 0,0,128 | 000080 |
135 | Black | 纯黑 | #000000 | 0,0,0 | 000000 |