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'),
'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 deviationcolor(deviation):
return 'rgb({}, {}, {})'.format(*get_deviation_color(deviation))
def deviationcolor(deviation):
return 'rgb({}, {}, {})'.format(*get_deviation_color(deviation))
