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()