[python] openpyxl 엑셀 셀병합, 해제와 셀정렬 설정

https://hostramus.tistory.com/103

파이썬 엑셀(Excel) 04. 엑셀 셀 병합, 해제, 정렬 설정

import openpyxl as oxl
from openpyxl.styles import Font, Alignment

wb = oxl.Workbook()
ws = wb.active

ws.merge_cells('A1:D1')
ws.merge_cells(start_row=2,start_column=1,end_row=2,end_column=4)

ws.unmerge_cells('A2:D2')

ws['A1'] = 123
ws['A1'].font = Font(size=35)

ws['A1'].alignment = Alignment(horizontal='center', vertical='bottom')

wb.save('test04.xlsx')

 

ws.merge_cells(2,1,2,4) => 이렇게 하면 안됨, 다음과 같이 해야함 (python3 기준)

ws.merge_cells(start_row=2,start_column=1,end_row=2,end_column=4)