blob: e5df528a49260d9dc6654a2c8361dd569f00ef92 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
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)
|
