for col in w_sheet.columns:
    for cell in col:
        alignment_obj = cell.alignment.copy(horizontal='center', vertical=
            'center')
cell.alignment = alignment_obj
Горизонтальное выравнивание текста в openpyxl