Python-сообщество

 from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill, Border, Side, Alignment
# Create a new workbook and select the active worksheet
wb = Workbook()
ws = wb.active
# Define the default style
default_font = Font(name='Arial', size=12, bold=True)
default_fill = PatternFill(start_color='FFFF00', end_color='FFFF00', fill_type='solid')
default_border = Border(left=Side(style='thin'), right=Side(style='thin'),
                        top=Side(style='thin'), bottom=Side(style='thin'))
default_alignment = Alignment(horizontal='center', vertical='center')
# Apply the default style to a range of cells
for row in ws.iter_rows(min_row=1, max_row=10, min_col=1, max_col=5):
    for cell in row:
        cell.font = default_font
        cell.fill = default_fill
        cell.border = default_border
        cell.alignment = default_alignment
# Save the workbook
wb.save('styled_workbook.xlsx')