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)