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 9 months ago
- JSONRequestMiddleware adds a .json() method to your HttpRequests by cdcarter 9 months, 1 week ago
- Serializer factory with Django Rest Framework by julio 1 year, 4 months ago
- Image compression before saving the new model / work with JPG, PNG by Schleidens 1 year, 4 months ago
- Help text hyperlinks by sa2812 1 year, 5 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.