Pandas带格式导出为xlsx文件

# 创建文件
writer = pd.ExcelWriter('订单.xlsx',engine='xlsxwriter')

# 创建百分数格式
percent_fmt = writer.book.add_format({'num_format': '0.00%'})

# 写入表格
df.to_excel(writer,sheet_name='订单详情',encoding='utf8',index=False)

# 调整格式
sheet = writer.sheets['订单详情']
sheet.set_column('A:B',20)  #设置AB列宽20
sheet.set_column('C:D',20, percent_fmt)  #设置AB列宽20,百分数单元格格式
sheet.set_row(2,30)  #设置第2行高30
# 写入公式
for index in range(0,len(df)):
  in_str = str(index+3)
  sheet.write_formula('O'+in_str,'=IFERROR(HYPERLINK(VLOOKUP(A{0},图片!$A$2:$D$1000,3,FALSE),"链接"),"")'.format(in_str))

# 保存文件
writer.save()