如何使用xlsxwriter模块在xlsx中放入千位分隔符

Question

使用xlsxwriter时，如何使xlsx文件包含列中带有逗号格式的数字(而不是字符串)的列?

我想做的是-将1000转换为1000，同时保留数值

失败……

#gives warning in cell (asking if it should be a number) + writes as string not number
sheet.write_string(0,0,re.sub("^0*|.?0*$","",format(val, ',.10f')) )
# writes as number with no warning, but no commas
sheet.write_number(0,0,1000) 

Answer 1

您需要设置单元格的格式来指定数字的表示方式:

num_fmt = workbook.add_format({'num_format': '#,###'})
...
sheet.write_number(0, 0, 1000, num_fmt)