day9-turtle绘图

颜色对照表

1.准备数据

import xlwt
data = xlwt.Style.colour_map

2.准备工作表

wb = xlwt.Workbook()
sheet = wb.add_sheet('颜色对照表')

3.将数据写入到工作表中

# 1）================写入第一行数据================
line1 = ['颜色', '颜色单词', '颜色值']

设置字体样式
style1 = xlwt.XFStyle()
font1.font = font1
font1.name = '黑体'
font1.bold = True
font1.height = 16 * 16

设置对齐方式
alignment1 = xlwt.Alignment()
style1.alignment = alignment1
alignment1.vert = xlwt.Alignment.VERT_CENTER
alignment1.horz = xlwt.Alignment.HORZ_CENTER

设置边框
boeder = xlwt.Borders()
style1.borders = border
border.left = 1
border.right = 1
border.top = 1
border.bottom = 1
border.left_colour = border.right_colour = border.top_colour = border.bottom_colour = 8

设置第一行的高度
sheet.row(0).height_mismatch = True
sheet.row(0).heighe = 10 * 60

for col in range(len(line1)):
    #设置每一列的宽度
    sheet.col(col).width = 20 * 256
    #写入数据
    sheet.write(0, col, line1[col], style1)
    
# 2)===============写入颜色数据====================
# 准备样式
style2 = xlwt.XFStyle()
font2 = xlwt.Font()
style2.font = font2
font2.height = 14 * 14
style2.alignment = alignment1
style2.borders = border

#写入数据
row = 1
for key in data:
    value = data[key]
    
    #第一列单元格的样式
    style3 = xlwt.XFStyle()
    style3.borders = border
    
    pattern = xlwt.Pattern()
    style3.pattern = pattern
    pattern.pattern = xlwt.Pattern.SOLID_PATTERN
    pattern.pattern_fore_colour = value
    
	#写入数据
	sheet.write(row, 0, '', style3)
	sheet.write(row, 1, key, style2)
	sheet.write(row,