def thick_border_white_cell_style(cell):
cell.font = Font(name='Verdana',
size=8,
bold=True,
color=DesignUtils.color_palette()['BLUE6'])
cell.border = Border(
left=Side(border_style='thick',
color=DesignUtils.color_palette()['BLUE6']),
right=Side(border_style='thick',
color=DesignUtils.color_palette()['BLUE6']),
top=Side(border_style='thick',
color=DesignUtils.color_palette()['BLUE6']),
bottom=Side(border_style='thick',
color=DesignUtils.color_palette()['BLUE6']))
cell.alignment = Alignment(horizontal='center', vertical='center')
return cell
def header_style_light_blue(cell):
cell.font = Font(name='Verdana', size=8, bold=True, color=colors.WHITE)
cell.border = Border(left=Side(border_style='thin',
color=colors.WHITE),
right=Side(border_style='thin',
color=colors.WHITE),
top=Side(border_style='thin', color=colors.WHITE),
bottom=Side(border_style='thin',
color=colors.WHITE))
cell.fill = PatternFill(patternType='solid',
fgColor=DesignUtils.color_palette()['BLUE2'])
cell.alignment = Alignment(horizontal='center',
vertical='center',
wrap_text=True)
return cell
def thick_border_fill_cell_style(cell):
cell.font = Font(name='Verdana',
size=8,
bold=True,
color=DesignUtils.color_palette()['BLUE6'])
cell.border = Border(
left=Side(border_style='thick',
color=DesignUtils.color_palette()['BLUE6']),
right=Side(border_style='thick',
color=DesignUtils.color_palette()['BLUE6']),
top=Side(border_style='thick',
color=DesignUtils.color_palette()['BLUE6']),
bottom=Side(border_style='thick',
color=DesignUtils.color_palette()['BLUE6']))
cell.fill = PatternFill(
patternType='solid',
fgColor=DesignUtils.color_palette()['LIGHTBERLINBLUE'])
cell.alignment = Alignment(horizontal='center', vertical='center')
return cell