xadmin将导入的excel文件保存到数据库

xadmin将导入的excel文件保存到数据库

class EnvironmentAdmin(object):
    import_excel = True  # 允许通过EXCEl导入
    def post(self, request,*args, **kwargs):
        if 'excel' in request.FILES:
            execl_file = request.FILES.get('excel')
            files = xlrd.open_workbook(filename=None, file_contents=execl_file.read())
            # 获取excel第一个表
            rsheet = files.sheet_by_index(0)
            nrows = rsheet.nrows
            IP_pattern = re.compile(
                r"^(?:[0-9]{1,3}\.){3}[0-9]{1,3}$")
            # 第一行一般为表头，所以从第二行开始取值
            # Environment.objects.create() # 一条一条的导入数据
            # Environment.objects.bulk_create() # 批量导入数据
            # Environment.objects.update_or_create() # 导入一条或更新数据
            # python manage.py dumpdata > netcheck.json
            for j in range(1, nrows):
                a = rsheet.row_values(j)[0]
                b = rsheet.row_values(j)[1]
                Environment.objects.create(a=a, b=b, proposer=str(request.user.username))
                
        return super(EnvironmentAdmin, self).post(request,args, kwargs)