| Line 158... |
Line 158... |
| 158 |
boldStyle.font = f
|
158 |
boldStyle.font = f
|
| 159 |
column = 0
|
159 |
column = 0
|
| 160 |
row = 0
|
160 |
row = 0
|
| 161 |
worksheet.write(row, 0, 'User Segment', boldStyle)
|
161 |
worksheet.write(row, 0, 'User Segment', boldStyle)
|
| 162 |
worksheet.write(row, 1, 'First Id', boldStyle)
|
162 |
worksheet.write(row, 1, 'First Id', boldStyle)
|
| 163 |
worksheet.write(row, 1, 'Last Id', boldStyle)
|
163 |
worksheet.write(row, 2, 'Last Id', boldStyle)
|
| 164 |
worksheet.write(row, 2, 'Username', boldStyle)
|
164 |
worksheet.write(row, 3, 'Username', boldStyle)
|
| 165 |
worksheet.write(row, 3, 'Name', boldStyle)
|
165 |
worksheet.write(row, 4, 'Name', boldStyle)
|
| 166 |
worksheet.write(row, 4, 'Mobile', boldStyle)
|
166 |
worksheet.write(row, 5, 'Mobile', boldStyle)
|
| 167 |
worksheet.write(row, 5, 'UserGroupId', boldStyle)
|
167 |
worksheet.write(row, 6, 'UserGroupId', boldStyle)
|
| 168 |
worksheet.write(row, 6, 'Group basis', boldStyle)
|
168 |
worksheet.write(row, 7, 'Group basis', boldStyle)
|
| 169 |
worksheet.write(row, 7, 'Users Count', boldStyle)
|
169 |
worksheet.write(row, 8, 'Users Count', boldStyle)
|
| 170 |
worksheet.write(row, 8, 'User last created', boldStyle)
|
170 |
worksheet.write(row, 9, 'User last created', boldStyle)
|
| 171 |
worksheet.write(row, 9, 'User first created', boldStyle)
|
171 |
worksheet.write(row, 10, 'User first created', boldStyle)
|
| 172 |
worksheet.write(row, 10, 'User Last Active On', boldStyle)
|
172 |
worksheet.write(row, 11, 'User Last Active On', boldStyle)
|
| 173 |
worksheet.write(row, 11, 'Order Last Created On', boldStyle)
|
173 |
worksheet.write(row, 12, 'Order Last Created On', boldStyle)
|
| 174 |
worksheet.write(row, 12, 'Total Orders', boldStyle)
|
174 |
worksheet.write(row, 13, 'Total Orders', boldStyle)
|
| 175 |
for r in result:
|
175 |
for r in result:
|
| 176 |
row += 1
|
176 |
row += 1
|
| 177 |
column = 0
|
177 |
column = 0
|
| 178 |
for data in r :
|
178 |
for data in r :
|
| 179 |
worksheet.write(row, column, int(data) if type(data) is float else data, datetime_format if type(data) is datetime.datetime else default_format)
|
179 |
worksheet.write(row, column, int(data) if type(data) is float else data, datetime_format if type(data) is datetime.datetime else default_format)
|