我们从Python开源项目中,提取了以下4个代码示例,用于说明如何使用xlwt.Borders()。
def set_style(name, height, bold=False, center=True): style = xlwt.XFStyle() # ????? font = xlwt.Font() # ??????? font.name = name # 'Times New Roman' font.bold = False font.color_index = 0 font.height = height # borders= xlwt.Borders() # borders.left= 6 # borders.right= 6 # borders.top= 6 # borders.bottom= 6 style.font = font # style.borders = borders alignment = xlwt.Alignment() alignment.horz = xlwt.Alignment.HORZ_CENTER if center == True: style.alignment = alignment return style
def set_excel_style(name, height, bold=False): """Set excel style. """ style = xlwt.XFStyle() # ????? font = xlwt.Font() # ??????? font.name = name # ??'Times New Roman' font.bold = bold font.color_index = 4 font.height = height if bold: borders = xlwt.Borders() borders.left = 6 borders.right = 6 borders.top = 6 borders.bottom = 6 style.borders = borders style.font = font return style
def set_style(name, height, bold=False): style = xlwt.XFStyle() # ????? font = xlwt.Font() # ??????? font.name = name # 'Times New Roman' font.bold = bold font.color_index = 4 font.height = height # borders= xlwt.Borders() # borders.left= 6 # borders.right= 6 # borders.top= 6 # borders.bottom= 6 style.font = font # style.borders = borders return style
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