我正在尝试生成在Excel中正确打开的CSV,但是使用StringIO而不是文件.
output = StringIO("\xef\xbb\xbf") # Tried just writing a BOM here, didn't work
fieldnames = ['id', 'value']
writer = csv.DictWriter(output, fieldnames, dialect='excel')
writer.writeheader()
for d in Data.objects.all():
writer.writerow({
'id': d.id,
'value': d.value
})
response = HttpResponse(output.getvalue(), content_type='text/csv')
response['Content-Disposition'] = 'attachment; filename=data.csv')
return response
这是Django视图的一部分,因此,我真的不想从事为此目的转储临时文件的工作.
我也尝试了以下方法:
response = HttpResponse(output.getvalue().encode('utf-8').decode('utf-8-sig'), content_type='text/csv')
没有运气
我该怎么做才能用BOM将输出文件正确编码为utf-8-sig,以便Excel将打开文件并正确显示多字节unicode字符?