我使用 xlsxwriter 包从我的 django 项目(完全是我的模型)中获取 excel 输出。 这些是我的字段:
date1 = models.DateField(default=datetime.date.today)
date2 = models.DateField(null=True,blank=True)
所有字段的输出都完全正确地嵌入到Excel中，唯一的问题是DateField的字段没有正确输出。这些字段的输出:
43603
我应该怎么做才能解决这个问题？
请您参考如下方法:
我终于找到了答案! 我阅读了有关 xlsxwriter 的更多信息，我还查看了 this文档。写在这里:
Dates and times in Excel are represented by real numbers, for example “Jan 1 2013 12:00 PM” is represented by the number 41275.5.
The integer part of the number stores the number of days since the epoch and the fractional part stores the percentage of the day.
最后的答案是:
To display the number as a date you must apply an Excel number format to it.
这里有一些例子:
import xlsxwriter
workbook = xlsxwriter.Workbook('date_examples.xlsx')
worksheet = workbook.add_worksheet()
# Widen column A for extra visibility.
worksheet.set_column('A:A', 30)
# A number to convert to a date.
number = 41333.5
# Write it as a number without formatting.
worksheet.write('A1', number) # 41333.5
format2 = workbook.add_format({'num_format': 'dd/mm/yy'})
worksheet.write('A2', number, format2) # 28/02/13
format3 = workbook.add_format({'num_format': 'mm/dd/yy'})
worksheet.write('A3', number, format3) # 02/28/13
workbook.close()
