django-admin 导入excel 批量上传

在使用django-admin带来直接管理数据库带来的便利的同时,我们希望数据能批量上传,为了达到此目的,我们需要django-admin-export 模块

 

一、安装模块

pip install django-import-export

二、settings.py注册模块

 

INSTALLED_APPS = [
    ....
    'import_export'
    ....
]

三、创建resource.py进行配置

先来看看我的 model ,然后再该model文件夹创建resource.py文件

class class_student(models.Model):
    sid = models.CharField(max_length=12, verbose_name='学生id')
    name = models.CharField(max_length=10, verbose_name='学生名称')
    class_room = models.CharField(max_length=50, verbose_name='教室')
    isroom = models.BooleanField(verbose_name="是否已经验证", default=False)

    def __str__(self):
        return self.name + "---" + self.class_room

    class Meat:
        db_table = 'class_student'

resource.py配置

 

from import_export import resources
from .models import *

class PersonResource(resources.ModelResource):
    class Meta:
        model = class_student

admin.py配置

from django.contrib import admin
from class_checkin.models import *
from import_export.admin import ImportExportModelAdmin

@admin.register(class_student)
class PersonAdmin(ImportExportModelAdmin):
    pass