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. All of this is done in-memory and on-the-fly, with no disk writes, thanks to the StringIO library.
This is http://djangosnippets.org/snippets/1151/ uploaded to pypi. Author is Tarken.
pip install django-excel-response xlwt
from excel_response import ExcelResponse def excelview(request): objs = SomeModel.objects.all() return ExcelResponse(objs)
from excel_response import ExcelResponse def excelview(request): data = [ ['Column 1', 'Column 2'], [1,2] [23,67] ] return ExcelResponse(data, 'my_data')
- Fix Django 1.4 admin_site ForeignKeyRawIdWidget issue
- Django admin filter by ranges of ages
- Ordering related objects in Django
- django-stdimage traceback "The '%s' attribute has no file associated with it"
- Python + CouchDB
- MemcachedKeyLengthError: Key length is > 250
- Django defer, only
- Retrieving elements in a specific order in django
- Django yandex and google maps integration