def write_workbook(file, screen_facility_id, fields, result_values): ''' Write API API Screen Result data to the Screen Result load file format ''' generic_xls_write_workbook( file, create_output_data(screen_facility_id, fields, result_values ))
def generic_xlsx_response(data): ''' Write out a data dictionary: dict keys: named sheets values: - if dict, convert to rows using dict_to_rows - if list, write directly as sheet rows - otherwise write as string ''' # using XlsxWriter for constant memory usage with NamedTemporaryFile(delete=False) as temp_file: generic_xls_write_workbook(temp_file, data) temp_file.seek(0, os.SEEK_END) size = temp_file.tell() temp_file.seek(0) logger.info('stream to response') _file = file(temp_file.name) response = StreamingHttpResponse(FileWrapper1(_file)) response['Content-Length'] = size response['Content-Type'] = XLSX_MIMETYPE return response
def write_workbook(file, screen_facility_id, fields, result_values): generic_xls_write_workbook( file, create_output_data(screen_facility_id, fields, result_values ))