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/
Project description
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Hashes for django-excel-response3-1.50.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 29b9290826cab81bcfe85fddee4b650a255af7b2fa29b40579b986f3fdf99608 |
|
MD5 | d5d0d58e346959f2c4e53386be2d76fa |
|
BLAKE2b-256 | 66a346d8ef19b82876c120cb6dc349603cb87b4d87baf39dfe0734b4a1a1ab06 |