Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.00 KB | None | 0 0
  1. Workbook_Competitor = openpyxl.load_workbook(Name_Workbook_Competitor)
  2. sheet = Workbook_Competitor['Вставка']
  3. print(len(Female_B_18_Kumite))
  4. if len(Female_B_18_Kumite) == 0:
  5.     print("Участники в этой категории отсутствуют")
  6. else:
  7.     i=0
  8.     for key in Female_B_18_Kumite:
  9.         cell = 'C' + str(i + 2)
  10.         print(Person[key]['DataPerson']['name'])
  11.         sheet[cell] = Person[key]['DataPerson']['name']
  12.         cell = 'B' + str(i + 2)
  13.         sheet[cell] = Person[key]['DataPerson']['team']
  14.         cell = 'D' + str(i + 2)
  15.         sheet[cell] = Person[key]['DataPerson']['birthday']
  16.         cell = 'E' + str(i + 2)
  17.         sheet[cell] = Person[key]['DataPerson']['KuDan']
  18.         cell = 'D' + str(i + 2)
  19.         sheet[cell] = Person[key]['DataPerson']['sportCategory']
  20.         cell = 'G' + str(i + 2)
  21.         sheet[cell] = Person[key]['DataPerson']['coach']
  22.         i += 1
  23.     Workbook_Competitor.save('Female_B_18_kumite.xlsx')
  24. print(" Готово")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement