-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathget_xls.py
86 lines (78 loc) · 2.22 KB
/
get_xls.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
from pandas import DataFrame
from register.models import user_data
refrence_id=[]
first_name=[]
last_name=[]
number=[]
email=[]
parent_father=[]
parent_mother=[]
dob=[]
tshirt_size=[]
address=[]
school=[]
grade=[]
gender=[]
exam_centre_1=[]
exam_centre_2=[]
exam_group_1=[]
exam_group_2=[]
flag_exam_centre_1=[]
flag_exam_centre_2=[]
flag_exam_group_1=[]
flag_exam_group_2=[]
flag_workshop=[]
flag_mpe_student=[]
image=[]
for o in user_data.objects.all():
refrence_id.append(o.refrence_id)
first_name.append(o.first_name)
last_name.append(o.last_name)
number.append(o.number)
email.append(o.email)
parent_father.append(o.parent_father)
parent_mother.append(o.parent_mother)
dob.append(o.dob)
tshirt_size.append(o.tshirt_size)
address.append(o.address)
school.append(o.school)
grade.append(o.grade)
gender.append(o.gender)
exam_centre_1.append(o.exam_centre_1)
exam_centre_2.append(o.exam_centre_2)
exam_group_1.append(o.exam_group_1)
exam_group_2.append(o.exam_group_2)
flag_exam_centre_1.append(o.flag_exam_centre_1)
flag_exam_centre_2.append(o.flag_exam_centre_2)
flag_exam_group_1.append(o.flag_exam_group_1)
flag_exam_group_2.append(o.flag_exam_group_2)
flag_workshop.append(o.flag_workshop)
flag_mpe_student.append(o.flag_mpe_student)
image.append(o.image)
json_data={}
json_data['refrence_id']=refrence_id
json_data['first_name']=first_name
json_data['last_name']=last_name
json_data['number']=number
json_data['email']=email
json_data['parent_father']=parent_father
json_data['parent_mother']=parent_mother
json_data['dob']=dob
json_data['tshirt_size']=tshirt_size
json_data['address']=address
json_data['school']=school
json_data['grade']=grade
json_data['gender']=gender
json_data['exam_centre_1']=exam_centre_1
json_data['exam_centre_2']=exam_centre_2
json_data['exam_group_1']=exam_group_1
json_data['exam_group_2']=exam_group_2
json_data['flag_exam_centre_1']=flag_exam_centre_1
json_data['flag_exam_centre_2']=flag_exam_centre_2
json_data['flag_exam_group_1']=flag_exam_group_1
json_data['flag_exam_group_2']=flag_exam_group_2
json_data['flag_workshop']=flag_workshop
json_data['flag_mpe_student']=flag_mpe_student
json_data['image']=image
df = DataFrame(json_data)
df.to_excel('user_data.xlsx', sheet_name='sheet1', index=False)