카테고리 없음

파이썬 엑셀 편집에서 글꼴 및 테두리 처리

벤치마킹 2019. 2. 16. 22:18 


파이썬 Font 및 테두리 , Fill 생상등 코드 

black_border = Border(right=Side(color='FF000000', border_style="thin"), left =Side(color='FF000000', border_style="thin"), 
                      top  =Side(color='FF000000', border_style="thin"), bottom = Side(color='FF000000', border_style="thin"))
thick_border = Border(right=Side(color='FF000000', border_style="thick"), left =Side(color='FF000000', border_style="thick"),
top  =Side(color='FF000000', border_style="thick"), bottom = Side(color='FF000000', border_style="thick"))

thin_border = Border(left=Side(style='thin'),
                     right=Side(style='thin'),
                     top=Side(style='thin'),
                     bottom=Side(style='thin'))

grayFill = PatternFill(start_color='DCDCDC',
                        end_color='DCDCDC',
                        fill_type='solid')

blueFill = PatternFill(start_color='ADD8E6',
                        end_color='ADD8E6',
                        fill_type='solid')


저작자표시 (새창열림)