def init_styles(self, workbook): self.styles = { 'default': xlwt.Style.default_style, 'avg': xlwt.easyxf('alignment: horiz centre; font: bold on; borders: left medium, top medium, bottom medium'), 'headline': xlwt.easyxf('font: bold on, height 400; alignment: horiz centre, vert centre, wrap on', num_format_str="0.0"), 'course': xlwt.easyxf('alignment: horiz centre, wrap on, rota 90; borders: left medium, top medium'), 'course_unfinished': xlwt.easyxf('alignment: horiz centre, wrap on, rota 90; borders: left medium, top medium; font: italic on'), 'total_voters': xlwt.easyxf('alignment: horiz centre; borders: left medium, bottom medium, right medium'), 'bold': xlwt.easyxf('font: bold on'), 'border_left': xlwt.easyxf('borders: left medium'), 'border_right': xlwt.easyxf('borders: right medium'), 'border_top_bottom_right': xlwt.easyxf('borders: top medium, bottom medium, right medium')} grade_base_style = 'pattern: pattern solid, fore_colour {}; alignment: horiz centre; font: bold on; borders: left medium' for i in range(0, self.NUM_GRADE_COLORS): grade = 1 + i*self.STEP color = get_grade_color(grade) palette_index = self.CUSTOM_COLOR_START + i style_name = self.grade_to_style(grade) self.create_style(workbook, grade_base_style, style_name, palette_index, color) deviation_base_style = 'pattern: pattern solid, fore_colour {}; alignment: horiz centre; borders: right medium' for i in range(0, self.NUM_DEVIATION_COLORS): deviation = i * self.STEP color = get_deviation_color(deviation) palette_index = self.CUSTOM_COLOR_START + self.NUM_GRADE_COLORS + i style_name = self.deviation_to_style(deviation) self.create_style(workbook, deviation_base_style, style_name, palette_index, color)
def init_styles(self, workbook): self.styles = { 'default': xlwt.Style.default_style, 'avg': xlwt.easyxf('alignment: horiz centre; font: bold on; borders: left medium, top medium, bottom medium'), 'headline': xlwt.easyxf('font: bold on, height 400; alignment: horiz centre, vert centre, wrap on', num_format_str="0.0"), 'course': xlwt.easyxf('alignment: horiz centre, wrap on, rota 90; borders: left medium, top medium, right medium'), 'total_voters': xlwt.easyxf('alignment: horiz centre; borders: left medium, bottom medium, right medium'), 'bold': xlwt.easyxf('font: bold on'), 'border_left': xlwt.easyxf('borders: left medium'), 'border_right': xlwt.easyxf('borders: right medium'), 'border_top_bottom_right': xlwt.easyxf('borders: top medium, bottom medium, right medium')} grade_base_style = 'pattern: pattern solid, fore_colour {}; alignment: horiz centre; font: bold on; borders: left medium' for i in range(0, self.NUM_GRADE_COLORS): grade = 1 + i*self.STEP color = get_grade_color(grade) palette_index = self.CUSTOM_COLOR_START + i style_name = self.grade_to_style(grade) color_name = style_name + "_color" self.create_color(workbook, color_name, palette_index, color) self.create_style(grade_base_style, style_name, color_name) self.create_style(grade_base_style + ', right medium', style_name + '_total', color_name) deviation_base_style = 'pattern: pattern solid, fore_colour {}; alignment: horiz centre; borders: right medium' for i in range(0, self.NUM_DEVIATION_COLORS): deviation = i * self.STEP color = get_deviation_color(deviation) palette_index = self.CUSTOM_COLOR_START + self.NUM_GRADE_COLORS + i style_name = self.deviation_to_style(deviation) color_name = style_name + "_color" self.create_color(workbook, color_name, palette_index, color) self.create_style(deviation_base_style, style_name, color_name) self.create_style(deviation_base_style + ', left medium', style_name + '_total', color_name)
def init_styles(self, workbook): self.styles = { "default": xlwt.Style.default_style, "avg": xlwt.easyxf( "alignment: horiz centre; font: bold on; borders: left medium, top medium, bottom medium" ), "headline": xlwt.easyxf( "font: bold on, height 400; alignment: horiz centre, vert centre, wrap on", num_format_str="0.0" ), "course": xlwt.easyxf( "alignment: horiz centre, wrap on, rota 90; borders: left medium, top medium, right medium" ), "total_voters": xlwt.easyxf("alignment: horiz centre; borders: left medium, bottom medium, right medium"), "bold": xlwt.easyxf("font: bold on"), "border_left": xlwt.easyxf("borders: left medium"), "border_right": xlwt.easyxf("borders: right medium"), "border_top_bottom_right": xlwt.easyxf("borders: top medium, bottom medium, right medium"), } grade_base_style = ( "pattern: pattern solid, fore_colour {}; alignment: horiz centre; font: bold on; borders: left medium" ) for i in range(0, self.NUM_GRADE_COLORS): grade = 1 + i * self.STEP color = get_grade_color(grade) palette_index = self.CUSTOM_COLOR_START + i style_name = self.grade_to_style(grade) color_name = style_name + "_color" self.create_color(workbook, color_name, palette_index, color) self.create_style(grade_base_style, style_name, color_name) self.create_style(grade_base_style + ", right medium", style_name + "_total", color_name) deviation_base_style = "pattern: pattern solid, fore_colour {}; alignment: horiz centre; borders: right medium" for i in range(0, self.NUM_DEVIATION_COLORS): deviation = i * self.STEP color = get_deviation_color(deviation) palette_index = self.CUSTOM_COLOR_START + self.NUM_GRADE_COLORS + i style_name = self.deviation_to_style(deviation) color_name = style_name + "_color" self.create_color(workbook, color_name, palette_index, color) self.create_style(deviation_base_style, style_name, color_name) self.create_style(deviation_base_style + ", left medium", style_name + "_total", color_name)
def gradecolor(grade): return 'rgb({}, {}, {})'.format(*get_grade_color(grade))
def gradecolor(grade): return "rgb({}, {}, {})".format(*get_grade_color(grade))