Python Styleframe으로 엑셀 출력

Jinno·2022년 8월 5일
0

python

목록 보기
20/21
from styleframe import StyleFrame, Styler

def genSheet(dfdata, sheetname):
    df = dfdata
    sf = StyleFrame(df, styler_obj=default_style)
    sf.apply_headers_style(styler_obj=header_style)
    sf.set_row_height(rows=sf.row_indexes, height=22)
    for column in df:    
        len_max = max(df[column].astype(str).map(len).max(), len(str(column)))
        sf.set_column_width(columns=[column], width=len_max*2.5)
    sf.to_excel(excel_writer, row_to_add_filters=0, columns_and_rows_to_freeze='A2',  sheet_name=sheetname)

excel_writer = StyleFrame.ExcelWriter('filename.xlsx')
default_style = Styler(font=utils.fonts.arial, font_size=12, date_format='YYYY-MM-DD', date_time_format='YYYY-MM-DD')
header_style = Styler(bold=True, font_size=12, bg_color='EBE7E6')

sheetname = ['name0', 'name1']
genSheet(df0, sheetname[0])
genSheet(df1, sheetname[1])

excel_writer.save()
profile
Innovation, 기록용

0개의 댓글