django excel xlwt


On a django site, I want to generate an excel file based on some data in the database.

I'm thinking of using xlwt, but it only has a method to save the data to a file. How can get the file to the HttpResponse object? Or maybe do you know a better library?

I've also found this snippet but it doesn't do what I need. All I want is a way to get the stream from the xlwt object to the response object (without writing to a temporary file)

12/24/2009 1:51:56 AM

Accepted Answer

neat package! i didn't know about this

According to the doc, the save(filename_or_stream) method takes either a filename to save on, or a file-like stream to write on.

And a Django response object happens to be a file-like stream! so just do Look the Django docs about generating PDFs with ReportLab to see a similar situation.

edit: (adapted from ShawnMilo's comment):

def xls_to_response(xls, fname):
    response = HttpResponse(mimetype="application/ms-excel")
    response['Content-Disposition'] = 'attachment; filename=%s' % fname
    return response

then, from your view function, just create the xls object and finish with

return xls_to_response(xls,'foo.xls')
11/19/2009 3:26:37 PM

***UPDATE: django-excel-templates no longer being maintained, instead try Marmir

Still in development as I type this but Django excel templates project aims to do what your asking.

Specifically look at the tests. Here is a simple case:

from django_excel_templates import *
from django_excel_templates.color_converter import *
from models import *
from django.http import HttpResponse

def xls_simple(request):

    ## Simple ##
    testobj = Book.objects.all()

    formatter = ExcelFormatter()
    simpleStyle = ExcelStyle(vert=2,wrap=1)

    simple_report = ExcelReport()
    filter = ExcelFilter(order='name,category,publish_date,about,bought_on,price,ebook')
    simple_report.addQuerySet(testobj,REPORT_HORZ,formatter, filter)

    response = HttpResponse(simple_report.writeReport(),mimetype='application/ms-excel')
    response['Content-Disposition'] = 'attachment; filename=simple_test.xls'
    return response

Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow