Django上传Excel或word读取内容并入库

Excel

#1. model 层
class Monitoring(models.Model):
    id = models.AutoField(primary_key=True,verbose_name="talentId")
    name = models.CharField(max_length=15, verbose_name="用户名称",null=True)
    workUnit = models.CharField(max_length=15, verbose_name="工作单位",null=True)
    professional = models.CharField(max_length=15, verbose_name="专业领域",null=True)
    storagetime = models.CharField(max_length=15, verbose_name="入库时间", null=True)


    class Meta:
        managed = True
        db_table = 'monitoring'

import xlrd
from django.utils import timezone
class upLoad(View):

    def post(self,request):
        f = request.FILES.get('file').read()
        wb = xlrd.open_workbook(filename=None,file_contents=f)
        table = wb.sheets()[0]
        row = table.nrows
        data_list=[]
        for i in range(1,row):
            col = table.row_values(i)
            datetime1 = timezone.now().strftime("%Y-%m-%d %H:%M:%S")
            data_list.append(Monitoring(name=col[0],workUnit=col[1],professional=col[2],storagetime=datetime1))
        Monitoring.objects.bulk_create(data_list)
        json_data = serializers.serialize('json',data_list)
        json_data = json.loads(json_data)
        json_data1 = [] # 返回上传的信息
        for i in json_data:
            json_data1.append(i['fields'])
        return JsonResponse({"coed":'200','data':json_data1})

Word

#1. model 层

class wordAddress(models.Model):
    word_id = models.AutoField(primary_key=True)
    word_path = models.CharField(max_length=500)

#2. view 层
import io
import docx
upload_file = request.FILES['file'].read()
    doc = docx.Document(io.BytesIO(upload_file))
    print(doc)
    # file = docx.Document("F:\\ocr\\image_json\\xxx.docx")
    for para in doc.paragraphs:
        print(para.text)
        wordAddress1 = wordAddress(word_path=para.text)
        wordAddress1.save()
    return HttpResponse('success')