我是编程新手。我上传了一个excel,希望将数据保存到数据库中。但是,当我试图通过检查stackoverflow来解决它时,我会遇到各种错误。这是我的密码
我的看法是:
def createSchool(request):
if request.method == 'POST' and request.FILES['excel']:
localvar= kidDetailsForm(request.POST)
myfile = request.FILES['excel']
book = xlrd.open_workbook(myfile.name)
sheet = book.sheet_by_index(0)
for r in range(1, sheet.nrows):
if localvar.is_valid():
temp = localvar.save(commit = False)
temp.childname = sheet.cell(r,0).value
temp.dob = sheet.cell(r,1).value
temp.sex = sheet.cell(r,2).value
temp.save()
return render(request, 'littleStar/createSchool.html')
return render(request, 'littleStar/createSchool.html')
我的表格:
class kidDetailsForm(forms.Form):
class Meta():
model = kidDetails
fields = ("childname","dob","sex")
我的模型:
class kidDetails(models.Model):
childname= models.CharField(max_length=245)
sex = models.CharField(max_length=245)
dob = models.DateField(max_length=245)
def __str__(self):
return self.childname
但是当我打印表格的时候。我看到了必需的错误。有没有办法绕过表单
我想上传excel并将数据保存到数据库。任何帮助都将非常感谢,谢谢
目前没有回答
相关问题 更多 >
编程相关推荐