当我读取Excel文件时,出现此“列表索引超出范围”错误。
views.py
a_list= studentData
list_iterator= iter(a_list)
next(list_iterator)
for detail in list_iterator:
stuname= detail[0]
print(stuname)
student_batch = Batch.objects.get(name=stuname)
email = detail[1]
rs_id = detail[2]
phone_number = str(detail[3])
dob = detail[4]
address = detail[5]
age = detail[6]
firstName = detail[7]
lastName = detail[8]
username = detail[9]
password = detail[10]
print(type(phone_number))
user=User.objects.create(
firstName = firstName,
lastName = lastName,
username = username,
)
user.set_password(password)
user.is_student = True
user.school = request.user.school
user.save()
user_ins = User.objects.get(username=username)
student=Student.objects.create(
user = user_ins,
email = email,
rs_id = rs_id,
dob = dob,
address = address,
age = age,
)
它实际上有效,我尝试打印数据,并且它也打印正确的数据。我不知道错误在哪里。 注意:studentData是包含用户数据的列表。然后,我使用next()跳过了第一次迭代,并从第二行开始。