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

 import openpyxl
from openpyxl.styles import Font, NamedStyle
from openpyxl import Workbook
from openpyxl import load_workbook
font = Font(name='Calibri',size=21,italic=False)
wb = load_workbook(filename='styled.xlsx' , data_only=True)
sheet = wb# получаем доступ к рабочему листу Sheet1
italic24Font = Font(size=24, italic=False) #создаетсястиль размер 11, наклонный шрифт
                                               # и привязываем его к переменной
sheet.font = italic24Font #задаем стиль ячейки
sheet = 'Здраствуй мир' # задаем текст ячейки

 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')