def _create_excel_response(raw_data_list, file_name):
response = HttpResponse(mimetype="application/ms-excel")
response['Content-Disposition'] = 'attachment; filename="%s.xls"' % (
file_name, )
wb = utils.get_excel_sheet(raw_data_list, 'data_log')
wb.save(response)
return response
def export_template(request, entity_type=None):
manager = get_database_manager(request.user)
if entity_type is None:
return HttpResponseRedirect(reverse(all_subjects))
fields, labels, field_codes = import_module.get_entity_type_fields(
manager, entity_type)
response = HttpResponse(mimetype='application/vnd.ms-excel')
response['Content-Disposition'] = 'attachment; filename="%s.xls"' % (
entity_type, )
form_model = get_form_model_by_entity_type(manager, [entity_type.lower()])
wb = get_excel_sheet([labels], entity_type)
form_code = form_model.form_code
add_codes_sheet(wb, form_code, field_codes)
try:
index_geocode = fields.index(GEO_CODE_FIELD_NAME)
except ValueError:
index_geocode = 0
ws = wb.get_sheet(0)
style = xlwt.XFStyle()
style.num_format_str = '@'
gps_col = ws.col(index_geocode)
gps_col.set_style(style)
wb.save(response)
return response
def create_workbook_response(self, data, field_codes):
response = HttpResponse(mimetype='application/vnd.ms-excel')
response['Content-Disposition'] = 'attachment; filename="%s.xls"' % slugify(self.file_name)
wb = get_excel_sheet(data, self.sheet_name)
add_codes_sheet(wb, self.form_code, field_codes)
self._add_styles(wb)
wb.save(response)
return response
def export_subject(request):
manager = get_database_manager(request.user)
query_text = request.POST.get('query_text', '')
subject_type = request.POST.get('subject_type', '').lower()
subject_list = SubjectQuery().query(request.user, subject_type, query_text)
form_model = get_form_model_by_entity_type(manager, [subject_type.lower()])
response = HttpResponse(mimetype='application/vnd.ms-excel')
response['Content-Disposition'] = 'attachment; filename="%s.xls"' % (
subject_type, )
field_codes = form_model.field_codes()
labels = get_subject_headers(form_model.form_fields)
raw_data = [labels]
for subject in subject_list:
raw_data.append(subject)
wb = get_excel_sheet(raw_data, subject_type)
add_codes_sheet(wb, form_model.form_code, field_codes)
wb.save(response)
return response
def export_subject(request):
entity_type = request.POST["entity_type"]
entity_list = request.POST.getlist("checked")
manager = get_database_manager(request.user)
all_data, fields, labels = load_all_subjects_of_type(
manager, filter_entities=include_of_type, type=entity_type)
response = HttpResponse(mimetype='application/vnd.ms-excel')
response['Content-Disposition'] = 'attachment; filename="%s.xls"' % (
entity_type, )
fields, labels, field_codes = import_module.get_entity_type_fields(
manager, entity_type)
raw_data = [labels]
for data in all_data:
if data['short_code'] in entity_list or len(entity_list) == 0:
raw_data.append(data['cols'])
wb = get_excel_sheet(raw_data, entity_type)
form_model = get_form_model_by_entity_type(manager, [entity_type.lower()])
add_codes_sheet(wb, form_model.form_code, field_codes)
wb.save(response)
return response
def _create_excel_response(raw_data_list,file_name):
response = HttpResponse(mimetype="application/ms-excel")
response['Content-Disposition'] = 'attachment; filename="%s.xls"'%(file_name,)
wb = utils.get_excel_sheet(raw_data_list, 'data_log')
wb.save(response)
return response