blob: 93f5bef681795c4e9c948036a34da826b5e7dbb4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
for row_index in range(sheet.nrows):
if sheet.cell(row_index, 0).value != '':
sci = sheet.cell(row_index, 0).value.split("(")[1].split(")")[0]
bc = BirdClass.objects.get(scientific_name__exact=sci)
common_name = sheet.cell(row_index, 1).value
sci_name = sheet.cell(row_index, 2).value
code = int(sheet.cell(row_index, 3).value)
bclass = bc
# create bird here
b, created = Bird.objects.get_or_create(
common_name=common_name,
scientific_name=sci_name,
code=code,
bird_class=bc
)
print(b)
|
