管理csv上载文件

Question

def createlist(request):
    if request.method == 'POST':
        files =  request.FILES['ListFile']
        print(type(files))
        csv_file = csv.DictReader(files)
        for i in csv_file:
            print(i)
    return HttpResponse("ok")

这给了
类'django.core.files.上载的文件.InMemoryUploadedFile'
_csv.错误：iterator应该返回字符串，而不是字节（是否以文本模式打开文件？）
这里我用ajax发布这个文件
js:

^{pr2}$

Answer 1

CSV不支持UTF8。它需要对类似文件的对象进行编码。有关详细信息，请参阅here。在

import codecs

def createlist(request):
    if request.method == "POST":
        utf8_file = codecs.EncodedFile(request.FILES["ListFile"],"utf-8")
        csv_file = csv.DictReader(utf8_file)
        for i in csv_file:
            print(i)
    return HttpResponse("ok")

Answer 2

使用编解码器.iterdecode，我解决了。我想这是由于Python3.x

import codecs

def createlist(request):
    if request.method == "POST":    
        fil =  request.FILES['ListFile']
        csvfile = csv.DictReader(codecs.iterdecode(fil, 'utf-8'))
        for i in csv_file:
            print(i)
    return HttpResponse("ok")