Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Workbook_Competitor = openpyxl.load_workbook(Name_Workbook_Competitor)
- sheet = Workbook_Competitor['Вставка']
- print(len(Female_B_18_Kumite))
- if len(Female_B_18_Kumite) == 0:
- print("Участники в этой категории отсутствуют")
- else:
- i=0
- for key in Female_B_18_Kumite:
- cell = 'C' + str(i + 2)
- print(Person[key]['DataPerson']['name'])
- sheet[cell] = Person[key]['DataPerson']['name']
- cell = 'B' + str(i + 2)
- sheet[cell] = Person[key]['DataPerson']['team']
- cell = 'D' + str(i + 2)
- sheet[cell] = Person[key]['DataPerson']['birthday']
- cell = 'E' + str(i + 2)
- sheet[cell] = Person[key]['DataPerson']['KuDan']
- cell = 'D' + str(i + 2)
- sheet[cell] = Person[key]['DataPerson']['sportCategory']
- cell = 'G' + str(i + 2)
- sheet[cell] = Person[key]['DataPerson']['coach']
- i += 1
- Workbook_Competitor.save('Female_B_18_kumite.xlsx')
- print(" Готово")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement