将dataframe的数据输出到excel设置格式和超链接,用的是pandas的函数ExcelWriter,不需要另外安装第三方包。
#如果输出的数据中有url用这句代码可以解决url超长的问题
writer = pd.ExcelWriter(f'{table_name}.xlsx',engine = 'xlsxwriter',options =
{'strings_to_urls': False})
df_all = pd.DataFrame()
df_all.to_excel(writer,index = False)
workbook = writer.book
# set excel header format
header_title = workbook.add_format({
'font_size': 11,
'bold': True,
'fg_color': '660000',
'border': 1,
'text_wrap': True,
"font_name": u"Consolas",
"font_color":'#FFFAFA',
"align" : 'center',
'valign':'vcenter'
})
# set excel value format
header_link = workbook.add_format({
'font_size':