def _create_excel_workbook(self, columns, submission_list, submission_type): file_name = export_filename(submission_type, self.project_name) workbook_file = AdvancedQuestionnaireSubmissionExporter(self.form_model, columns, self.local_time_delta, self.preferences).create_excel(submission_list, self.is_single_sheet) workbook_file.close() return file_name, workbook_file
def _create_response(self, columns, submission_list, submission_type, hide_codes_sheet=False): file_name = slugify(export_filename(submission_type, self.project_name)) workbook_file = AdvancedQuestionnaireSubmissionExporter(self.form_model, columns, self.local_time_delta, self.preferences).create_excel(submission_list, self.is_single_sheet) workbook_file.seek(0) response = HttpResponse(FileWrapper(workbook_file), mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") response['Content-Disposition'] = "attachment; filename=%s.xlsx" % file_name return response
def create_excel_response(self, submission_type, query_params): columns = SubmissionExcelHeader(self.form_model, submission_type).get_columns() entity_headers, paginated_query, query_with_criteria = SubmissionQuery(self.form_model, query_params).query_to_be_paginated( self.form_model.id, self.user) submission_list = query_with_criteria.values_dict(tuple(entity_headers)) header_list, formatted_values = SubmissionFormatter(columns).format_tabular_data(submission_list) return create_excel_response(header_list, formatted_values, export_filename(submission_type, self.project_name))
def _create_response(self, columns, submission_list, submission_type, hide_codes_sheet=False): header_list, submission_formatter = self._get_header_list(columns) return export_to_new_excel(header_list, submission_list, export_filename(submission_type, self.project_name), submission_formatter, hide_codes_sheet, questionnaire=self.form_model)
def _create_response(self, columns, submission_list, submission_type): header_list, submission_formatter = self._get_header_list(columns) return export_to_new_excel(header_list, submission_list, export_filename(submission_type, self.project_name), submission_formatter)