Python的xlsxwriter的输出格式控制

style0 = wb.add_format({'bold': 1})
style1 = wb.add_format({'align': 'left', 'font_size': 9, 'num_format':'yyyy-mm-dd'})
style2 = wb.add_format({'align': 'left', 'font_size': 9})
style3 = wb.add_format({'align': 'left', 'text_wrap':1,'bold': 1,'font_size': 9})

ItemStyle = workbook.add_format({
        'font_size':10,                #字体大小
        'bold':1,               #是否粗体
        'bg_color':'#101010',          #表格背景颜色
        'font_color':'#FEFEFE',        #字体颜色
        'align':'center',              #对齐方式，left,center,rigth,top,vcenter,bottom,vjustify
        'top':2,                       #上边框，后面参数是线条宽度
        'left':2,                      #左边框
        'right':2,                     #右边框
        'bottom':2                     #底边框
'text_wrap':1       #自动换行，可在文本中加 '\n'来控制换行的位置
'num_format':'yyyy-mm-dd'      #设定格式为日期格式，如：2017-07-01
})

#以下为设置数字格式的样例
format1 = workbook.add_format()
format2 = workbook.add_format()


format1.set_num_format('d mmm yyyy')  # Format string.
format2.set_num_format(0x0F)          # Format index.


format01.set_num_format('0.000')
worksheet.write(1, 0, 3.1415926, format01)       # -> 3.142


format02.set_num_format('#,##0')
worksheet.write(2, 0, 1234.56, format02)         # -> 1,235


format03.set_num_format('#,##0.00')
worksheet.write(3, 0, 1234.56, format03)         # -> 1,234.56


format04.set_num_format('0.00')
worksheet.write(4, 0, 49.99, format04)           # -> 49.99


format05.set_num_format('mm/dd/yy')
worksheet.write(5, 0, 36892.521, format05)       # -> 01/01/01


format06.set_num_format('mmm d yyyy')
worksheet.write(6, 0, 36892.521, format06)       # -> Jan 1 2001


format07.set_num_format('d mmmm yyyy')
worksheet.write(7, 0, 36892.521, format07)       # -> 1 January 2001


format08.set_num_format('dd/mm/yyyy hh:mm AM/PM')
worksheet.write(8, 0, 36892.521, format08)      # -> 01/01/2001 12:30 AM


format09.set_num_format('0 "dollar and" .00 "cents"')
worksheet.write(9, 0, 1.87, format09)           # -> 1 dollar and .87 cents


# Conditional numerical formatting.
# [Black] [Blue] [Cyan] [Green] [Magenta] [Red] [White] [Yellow]
format10.set_num_format('[Green]General;[Red]-General;General')
worksheet.write(10, 0, 123, format10)  # > 0 Green
worksheet.write(11, 0, -45, format10)  # < 0 Red
worksheet.write(12, 0,   0, format10)  # = 0 Default color


# Zip code.
format11.set_num_format('00000')
worksheet.write(13, 0, 1209, format11)