how to generate a (real) excel file as an HTTP response with xlwt
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | import xlwt
def tool_excel_export(self, request, obj, button):
response = HttpResponse(mimetype="application/ms-excel")
response['Content-Disposition'] = 'attachment; filename=file.xls'
wb = xlwt.Workbook()
ws = wb.add_sheet('Sheetname')
ws.write(0, 0, 'Firstname')
ws.write(0, 1, 'Surname')
ws.write(1, 0, 'Hans')
ws.write(1, 1, 'Muster')
wb.save(response)
return response
|
More like this
- Template tag - list punctuation for a list of items by shapiromatron 3 months, 1 week ago
- JSONRequestMiddleware adds a .json() method to your HttpRequests by cdcarter 3 months, 2 weeks ago
- Serializer factory with Django Rest Framework by julio 10 months, 2 weeks ago
- Image compression before saving the new model / work with JPG, PNG by Schleidens 11 months ago
- Help text hyperlinks by sa2812 12 months ago
Comments
IE seems to require that file.xls be "file.xls" Or it will puke saying it can't save the file if your url ends in a slash.
#
The following is also missing:
Finally, the MIME type is wrong, it should be like this:
#
Please login first before commenting.