반응형
소스코드
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
ws.merge_cells(start_row=2, start_column=2, end_row=2, end_column=5)
ws.cell(row=2, column=2).value = 'MERGE TEST'
wb.save('testexcel.xlsx')결과
openpyxl 로 cell 테두리 적용
import openpyxl as xls wb = xls.Workbook() ws = wb.active box = Border( left=Side(border_style="thin", color='00000000'), right=Side(border_style="thin", color='00000000'), top=Side(border_style="th..
korearocker.tistory.com
반응형