def get_default_style(self):
"""
* Colour index
8 through 63. 0 = Black, 1 = White, 2 = Red, 3 = Green, 4 = Blue, 5 = Yellow, 6 = Magenta,
7 = Cyan, 16 = Maroon, 17 = Dark Green, 18 = Dark Blue, 19 = Dark Yellow , almost brown),
20 = Dark Magenta, 21 = Teal, 22 = Light Gray, 23 = Dark Gray, the list goes on... sty
* Borders
borders.left, borders.right, borders.top, borders.bottom
May be: NO_LINE, THIN, MEDIUM, DASHED, DOTTED, THICK, DOUBLE, HAIR, MEDIUM_DASHED,
THIN_DASH_DOTTED, MEDIUM_DASH_DOTTED, THIN_DASH_DOT_DOTTED, MEDIUM_DASH_DOT_DOTTED,
SLANTED_MEDIUM_DASH_DOTTED, or 0x00 through 0x0D.
borders = xlwt.Borders()
borders.left = xlwt.Borders.THIN
borders.right = xlwt.Borders.THIN
borders.top = xlwt.Borders.THIN
borders.bottom = xlwt.Borders.THIN
borders.left_colour = 0x00
borders.right_colour = 0x00
borders.top_colour = 0x00
borders.bottom_colour = 0x00
style.borders = borders
* Fonts
style.font = xlwt.Font()
style.font.height = 8 * 20
style.font.colour_index = 22
* Alignment
style.alignment = xlwt.Alignment()
style.alignment.horz = xlwt.Alignment.HORZ_LEFT
style.alignment.vert = xlwt.Alignment.VERT_CENTER
* Pattern
May be: NO_PATTERN, SOLID_PATTERN, or 0x00 through 0x12
style.pattern = xlwt.Pattern()
style.pattern.pattern = xlwt.Pattern.SOLID_PATTERN
style.pattern.pattern_fore_colour = 23
"""
style = xlwt.XFStyle()
return style
评论列表
文章目录