with pd.ExcelWriter(file_name, engine='xlsxwriter') as writer:
fmt = writer.book.add_format({'num_format': '¥#,##0.00;[红色]¥ -#,##0.00'})
df.to_excel(writer, sheet_name='xxx', index=False)
writer.sheets['stats'].set_column('K:K', None, fmt)
读取就是简单的 pd.read_excel(...)
