xlwt 里easyxf能理解的颜色预览

来源：互联网发布：nokia windows phone 编辑：程序博客网时间：2024/06/05 18:43

aquadark_greengray40light_orangeperiwinkletealblackdark_green_egagray50light_turquoisepinkteal_egabluedark_purplegray80light_yellowplumturquoiseblue_graydark_redgreenlimepurple_egavioletbright_greendark_red_egaice_bluemagenta_egaredwhitebrowndark_tealindigoocean_blueroseyellowcoraldark_yellowivoryolive_egasea_greencyan_egagoldlavenderolive_greensilver_egadark_bluegray_egalight_blueorangesky_bluedark_blue_egagray25light_greenpale_bluetan

easyxf 能理解以上颜色种类，写了脚本生成对应的颜色进行预览， xlwt_colour 的第一列填写以上颜色种类，脚本运行完后第二列生成对应颜色

#!/usr/bin/env python# coding=utf-8from xlrd import open_workbookfrom xlwt import easyxf, XFStyle, Patternfrom xlutils.copy import copydef set_style(colour):    return easyxf(        'pattern: pattern solid, fore_colour %s;' % colour    )rbook = open_workbook('xlwt_colour.xls')rsheet = rbook.sheet_by_index(0)wbook = copy(rbook)wsheet = wbook.get_sheet(0)rows = rsheet.nrowsfor r in range(rows):    coltxt = str(rsheet.cell(r, 0).value)    wsheet.write(r, 1, None, set_style(coltxt))wsheet.col(0).width = 6000wsheet.col(1).width = 3000wbook.save('xlwt_colour.xls')

0 0