Python generic_xls_write_workbook Examples

Example #1

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 ))

Example #2

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

Example #3

File: screen_result_importer.py Project: gmat/lims

def write_workbook(file, screen_facility_id, fields, result_values):
    generic_xls_write_workbook(
        file, 
        create_output_data(screen_facility_id, fields, result_values ))