django-admin 导入excel 批量上传

短命女 2023-01-13 04:10 129阅读 0赞

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

# 一、安装模块 #

pip install django-import-export

# 二、settings.py注册模块 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L084MDg4_size_16_color_FFFFFF_t_70][]

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

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L084MDg4_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L084MDg4_size_16_color_FFFFFF_t_70]: /images/20221022/c1028d7c8932459fb89a7dbb8c9806e7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L084MDg4_size_16_color_FFFFFF_t_70 1]: /images/20221022/3907b9d28f524813872fb40e6f4012c1.png