Openpyxl устанавливает стиль ячейки ⇐ Python

[Anonymous]

Я пытаюсь создать функцию, которая применяла бы выбранные стили к одной или нескольким ячейкам.
На данный момент это выглядит так:
from openpyxl.styles import Font
from openpyxl.styles.alignment import Alignment
from openpyxl.styles.borders import Border
from openpyxl.styles.fills import Color
from openpyxl.worksheet.worksheet import Worksheet

def set_cell_style(ws: Worksheet, start_row: int, start_col: int,
end_row: int = None, end_col: int = None,
font: Font = None, fill: Color = None, border: Border = None,
number_format: str = None, alignment: Alignment = None):
"""Applies a new style to a cell or cells"""
if not end_row:
end_row = start_row
if not end_col:
end_col = start_col

for row in range(start_row, end_row + 1):
for col in range(start_col, end_col + 1):
if font:
ws.cell(row = row, column = col).font = font
if fill:
ws.cell(row = row, column = col).fill = fill
if border:
ws.cell(row = row, column = col).border = border
if number_format:
ws.cell(row = row, column = col).number_format = number_format
if alignment:
ws.cell(row = row, column = col).alignment = alignment
return

Затем в каком-то новом файле я создал такие стили:
from openpyxl.styles.fills import PatternFill, Color
from openpyxl.styles import Font
from openpyxl.styles.borders import Border, Side

light_gray_fill = PatternFill(patternType='solid', fgColor=Color(rgb='%02x%02x%02x' % (221, 221, 221)))
summ_fill = PatternFill(patternType='solid', fgColor=Color(rgb='%02x%02x%02x' % (200, 255, 255)))
header_fill = PatternFill(patternType='solid', fgColor=Color(rgb='%02x%02x%02x' % (0, 113, 193)))

header_font1 = Font(name="Monaco", size=11, color='FFFFFF')
header_font = Font(name="Monaco", size=10, color='FFFFFF')
common_font = Font(name="Monaco", size=10, color='000000')
thin_border = Border(left=Side(style='thin'), right=Side(style='thin'), top=Side(style='thin'), bottom=Side(style='thin'))
bottom_border = Border(left=Side(style='thin'), right=Side(style='thin'), top=Side(style='thin'), bottom=Side(style='medium'))

Есть мысли о том, как я могу улучшить эту функцию?
Например, чтобы не повторяться, вы можете присваивать значения, используя for:< /p>
def set_cell_style(ws: Worksheet, start_row: int, start_col: int,
end_row: int = None, end_col: int = None,
font: Font = None, fill: Color = None, border: Border = None,
number_format: str = None, alignment: Alignment = None):
"""Applies a new style to a cell or cells"""
if not end_row:
end_row = start_row
if not end_col:
end_col = start_col
for arg in list(locals().keys())[5:]:
for row in range(start_row, end_row + 1):
for col in range(start_col, end_col + 1):
value = locals()[arg]
if value:
ws.cell(row = row, column = col).__setattr__(arg, value)
return


Подробнее здесь: https://stackoverflow.com/questions/792 ... cell-style