十六进制颜色编码表

在调整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格式对应颜色
1White纯白#FFFFFF255,255,255FFFFFF
2Ivory象牙色#FFFFF0255,255,240FFFFF0
3LightYellow浅黄色#FFFFE0255,255,224FFFFE0
4LemonYellow柠檬黄#FFFF00255,255,0FFFF00
5Yellow黄色#FFFF00255,255,0FFFF00
6Snow#FFFAFA255,250,250FFFAFA
7FloralWhite花的白色#FFFAF0255,250,240FFFAF0
8LemonChiffon柠檬薄纱#FFFACD255,250,205FFFACD
9Cornislk玉米色#FFF8DC255,248,220FFF8DC
10SeaShell海贝壳#FFF5EE255,245,238FFF5EE
11LavenderBlush偏红的淡紫色#FFF0F5255,240,245FFF0F5
12PapayaWhip番木瓜#FFEFD5255,239,213FFEFD5
13BlanchedAlmond漂白的杏仁#FFEBCD255,235,205FFEBCD
14MistyRose薄雾玫瑰#FFE4E1255,228,225FFE4E1
15Bisque(浓汤)乳脂,番茄等#FFE4C4255,228,196FFE4C4
16Moccasin鹿皮鞋#FFE4B5255,228,181FFE4B5
17NavajoWhiteNavajo白#FFDEAD255,222,173FFDEAD
18PeachPuff桃色#FFDAB9255,218,185FFDAB9
19Gold#FFD700255,215,0FFD700
20Pink粉红#FFC0CB255,192,203FFC0CB
21LightPink浅粉色#FFB6C1255,182,193FFB6C1
22Orange橙色#FFA500255,165,0FFA500
23LightSalmon浅鲜肉(鲑鱼)色#FFA07A255,160,122FFA07A
24DarkOrange深橙色#FF8C00255,140,0FF8C00
25Coral珊瑚#FF7F50255,127,80FF7F50
26HotPink热情的粉红#FF69B4255,105,180FF69B4
27Tomato番茄#FF6347255,99,71FF6347
28OrangeRed橙红色#FF4500255,69,0FF4500
29DeepPink深粉色#FF1493255,20,147FF1493
30BrightPurple亮紫色#FF00FF255,0,255FF00FF
31PurePurple纯紫#FF00FF255,0,255FF00FF
32Red纯红#FF0000255,0,0FF0000
33OldLace老饰带#FDF5E6253,245,230FDF5E6
34LightGoldenrodYellow浅秋麒麟黄#FAFAD2250,250,210FAFAD2
35Linen亚麻布#FAF0E6250,240,230FAF0E6
36AntiqueWhite古代的白色#FAEBD7250,235,215FAEBD7
37Salmon鲜肉(鲑鱼)色#FA8072250,128,114FA8072
38GhostWhite幽灵的白色#F8F8FF248,248,255F8F8FF
39MediumSpringGreen适中的春天的绿色#F5FFFA245,255,250F5FFFA
40WhiteSmoke白烟#F5F5F5245,245,245F5F5F5
41Wheat小麦色#F5DEB3245,222,179F5DEB3
42SandyBrown沙棕色#F4A460244,164,96F4A460
43Azure蔚蓝色#F0FFFF240,255,255F0FFFF
44Honeydew蜂蜜#F0FFF0240,255,0F0FFF0
45AliceBlue爱丽丝蓝#F0F8FF240,248,255F0F8FF
46Khaki卡其布#F0E68C240,230,140F0E68C
47LightCoral淡珊瑚色#F08080240,128,128F08080
48PaleGodenrod灰秋麒麟#EEE8AA238,232,170EEE8AA
49Violet紫罗兰#EE82EE238,130,238EE82EE
50DarkSalmon深鲜肉(鲑鱼)色#E9967A233,150,122E9967A
51Lavender薰衣草花的淡紫色#E6E6FA230,230,250E6E6FA
52LightCyan淡青色#E1FFFF225,255,255E1FFFF
53BrulyWood结实的树#DEB887222,184,135DEB887
54plum李子#DDA0DD221,160,221DDA0DD
55GainsboroGainsboro#DCDCDC220,220,220DCDCDC
56Crimson猩红#DC143C220,20,60DC143C
57PaleVioletRed苍白的紫罗兰红色#DB7093219,112,147DB7093
58GoldEnrod秋麒麟#DAA520218,165,32DAA520
59Orchid兰花的紫色#DA70D6218,112,214DA70D6
60Thistle#D8BFD8216,191,216D8BFD8
61LightGray浅灰色#D3D3D3211,211,211D3D3D3
62Tan晒黑#D2B48C210,180,140D2B48C
63Chocolate巧克力#D2691E210,105,30D2691E
64Peru秘鲁#CD853F205,133,63CD853F
65IndianRed印度红#CD5C5C205,92,92CD5C5C
66MediumVioletRed适中的紫罗兰红色#C71585199,21,133C71585
67Silver银白色#C0C0C0192,192,192C0C0C0
68DarkKhaki深卡其布#BDB76B189,183,107BDB76B
69RosyBrown玫瑰棕色#BC8F8F188,143,143BC8F8F
70MediumOrchid适中的兰花紫#BA55D3186,85,211BA55D3
71FireBrick耐火砖#B22222178,34,34B22222
72PowDerBlue火药蓝#B0E0E6176,224,230B0E0E6
73LightSteelBlue淡钢蓝#B0C4DE176,196,222B0C4DE
74PaleTurquoise苍白的绿宝石#AFEEEE175,238,238AFEEEE
75GreenYellow绿黄色#ADFF2F173,255,47ADFF2F
76LightBLue淡蓝#ADD8E6173,216,230ADD8E6
77DarkGray深灰色#A9A9A9169,169,169A9A9A9
78Brown棕色#A52A2A165,42,42A52A2A
79Sienna黄土赭色#A0522D160,82,45A0522D
80DarkOrchid深兰花紫#9932CC153,50,2049932CC
81PaleGreen苍白的绿色#98FB98152,251,15298FB98
82DarkVoilet深蓝紫色#9400D3148,0,2119400D3
83MediumPurple适中的蓝紫色#9370DB147,112,2199370DB
84LightGreen淡绿色#90EE90144,238,14490EE90
85DarkSeaGreen深海洋绿#8FBC8F143,188,1438FBC8F
86SaddleBrown马鞍棕色#8B4513139,69,198B4513
87DarkPurple深紫色#8B008B139,0,1398B008B
88DarkRed深红色#8B0000139,0,08B0000
89BlueViolet深紫罗兰的蓝色#8A2BE2138,43,2268A2BE2
90LightSkyBlue淡蓝色#87CEFA135,206,25087CEFA
91SkyBlue天蓝色#87CEEB135,206,23587CEEB
92Gray灰色#808080128,128,128808080
93Olive橄榄绿#808000128,128,0808000
94Purple紫色#800080128,0,128800080
95Maroon栗色#800000128,0,0800000
96BabyGreen绿玉#7FFFAA127,255,1707FFFAA
97Chartreuse查特酒绿#7FFF00127,255,07FFF00
98LawnGreen草坪绿#7CFC00124,252,07CFC00
99MediumSlateBlue适中的板岩暗蓝灰色#7B68EE123,104,2387B68EE
100LightSlateGray浅石板灰#778899119,136,153778899
101SlateGray石板灰#708090112,128,144708090
102Beige米色(浅褐色)#6B8E23107,142,356B8E23
103SlateBlue板岩暗蓝灰色#6A5ACD106,90,2056A5ACD
104DimGray暗淡的灰色#696969105,105,105696969
105CornflowerBlue矢车菊的蓝色#6495ED100,149,2376495ED
106CadetBlue军校蓝#5F9EA095,158,1605F9EA0
107OliveDrab橄榄土褐色(褐绿色)#556B2F85,107,47556B2F
108Indigo靛青#4B008275,0,1304B0082
109MediumTurquoise适中的绿宝石#48D1CC72,209,20448D1CC
110DarkSlateBlue深岩暗蓝灰色#483D8B72,61,139483D8B
111SteelBlue钢蓝#4682B470,130,1804682B4
112RoyalBlue宝蓝#4169E165,105,2254169E1
113Turquoise绿宝石#40E0D064,224,20840E0D0
114SpringGreen春天的绿色#3CB37160,179,1133CB371
115LimeGreen酸橙绿#32CD3250,205,5032CD32
116DarkSlateGray深石板灰#2F4F4F47,79,792F4F4F
117SeaGreen海洋绿#2E8B5746,139,872E8B57
118ForestGreen森林绿#228B2234,139,34228B22
119LightSeaGreen浅海洋绿#20B2AA32,178,17020B2AA
120DodgerBlue道奇蓝#1E90FF30,144,2551E90FF
121MidnightBlue午夜的蓝色#19197025,25,112191970
122Aqua,Cyan水绿色,青色#00FFFF0,255,25500FFFF
123MintCream薄荷奶油#00FF7F0,255,12700FF7F
124Green绿色#00FF000,255,000FF00
125MediumAquamarine适中的碧绿色#00FA9A0,250,15400FA9A
126DarkTurquoise深绿宝石#00CED10,206,20900CED1
127DeepSkyBlue深天蓝#00BFFF0,191,25500BFFF
128DarkCyan深青色#008B8B0,139,139008B8B
129Teal水鸭色#0080800,128,128008080
130DarkGreen深绿色#0064000,100,0006400
131Blue蓝色#0000FF0,0,2550000FF
132MediumBlue适中的蓝色#0000CD0,0,2050000CD
133DarkBlue深蓝色#00008B0,0,13900008B
134Navy海军蓝,深靛蓝#0000800,0,128000080
135Black纯黑#0000000,0,0000000
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值