[python] openpyxl 파이썬 엑셀 셀테두리 셀크기 설정

https://hostramus.tistory.com/104

파이썬 엑셀(Excel) 05. 셀 테두리 설정, 셀 크기 설정

import openpyxl as oxl
from openpyxl.styles import Border

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

ws['A1'].border = Border(left=borders.Side(style='thin'))

for i in range(1,5,1):
    for j in range(1,5,1):
        ws.cell(row=i, column=j, value=i*j).border = Border(right=borders.Side(style='thin'))
        
ws.column_dimensions['A'].width = 30
ws.row_dimensions[1].height = 30

wb.save('test055.xlsx')