This is http://djangosnippets.org/snippets/1151/ uploaded to pypi. Author is Tarken.
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.
Installation
pip install django-excel-response xlwt
Usage
from excel_response import ExcelResponse
def excelview(request):
objs = SomeModel.objects.all()
return ExcelResponse(objs)
or:
from excel_response import ExcelResponse
def excelview(request):
data = [
['Column 1', 'Column 2'],
[1,2]
[23,67]
]
return ExcelResponse(data, 'my_data')
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file django-excel-response-1.0.tar.gz.
File metadata
- Download URL: django-excel-response-1.0.tar.gz
- Upload date:
- Size: 2.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
b708184ee1c93ac1769e72c49bae5666b9ffce0892daa0b54c7cbec98e1c6014
|
|
| MD5 |
09001aa9c8b6dadbe6111e902adbba32
|
|
| BLAKE2b-256 |
3b88ed54fd80c752df475fbb84402fbbcec9e0cdbcf5a4c3051e9809f5b18630
|
