skip to navigation
skip to content

django-excel-response3 1.51

A subclass of HttpResponse which will transform a QuerySet, or sequence of sequences, into either an Excel spreadsheet or CSV file formatted for Excel, depending on the amount of data. http://github.com/danpetrikin/django-excel-response/

django-excel-response3

This is an overhaul of https://pypi.python.org/pypi/django-excel-response which was originally http://djangosnippets.org/snippets/1151/

  • added class detection for values, and will use the value str(class_value)
  • added support for floats, dollar strings, and comma separated number strings that were broken in other forks
  • refactored the code to resemble an actual class, as opposed to one giant init function
  • removed the performance killing import every time you write a sheet, xlwt is required. If you don’t like it use a CSV writer
  • refactored the CSV writing portion of the code to actually use python’s csv class
  • added width auto adjustment

Usage

from excel_response3 import ExcelResponse

def excelview(request):
    objs = SomeModel.objects.all()
    return ExcelResponse(objs)

or

from excel_response3 import ExcelResponse

def excelview(request):
    data = [
        ['Column 1', 'Column 2'],
        [1,2]
        [23,67]
    ]
    return ExcelResponse(data, 'my_data')

Constructor Kwargs

  • headers - an array containing column headers
  • output_name - maintaining this kwarg, but tries first to use the 2nd arg passed when defining the class
  • force_csv - forcibly respond with csv, defaults to False
  • encoding - defaults to ‘utf8’
  • sheet_name - defaults to ‘Sheet 1’
  • blanks_for_none - replace None values with ’’, defaults to True
  • auto_adjust_width - adjust width of each column automatically, defaults to True
 
File Type Py Version Uploaded on Size
django-excel-response3-1.51.tar.gz (md5) Source 2016-06-09 3KB