openpyxl セルの書式設定で縦書きにする

A1セルを縦書きにする

import openpyxl
from openpyxl.styles.alignment import Alignment

filename = 'test.xlsx'
wb = openpyxl.load_workbook(filename=filename)
ws = wb.active

ws['A1'].alignment = Alignment(textRotation = 255)

wb.save(filename)

A1セルからE1セルを縦書きにする

import openpyxl
from openpyxl.styles.alignment import Alignment

filename = 'test.xlsx'
wb = openpyxl.load_workbook(filename=filename)
ws = wb.active

for row in ws['A1:E1']:
    for cell in row:
        cell.alignment = Alignment(textRotation = 255)

wb.save(filename)