python3 Excel 中央揃え

テーマ:

import openpyxl as px
from openpyxl.styles import Alignment

filepath = r'c:\sample/test.xlsx'
savepath = r'c:\sample/test2.xlsx'
wb = px.load_workbook(filepath)
ws = wb.get_sheet_by_name('Sheet1')

ws.cell(row = 3, column = 2, value = "指定なし")
ws.cell(row = 3, column = 3, value = "中央揃え").alignment = Alignment(horizontal='center',vertical = 'center',wrap_text=True)

wb.save(savepath)

AD