Skip to main content

Django package to easily render Excel spreadsheets

Project description

Latest Version Test/build status Code coverage

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.


pip install django-excel-response

Provided Classes

  • excel_response.response.ExcelResponse

    Accepted arguments:

    • data - A queryset or list of lists from which to construct the output
    • output_filename - The filename which should be suggested in the http response, minus the file extension (default: excel_data)
    • worksheet_name - The name of the worksheet inside the spreadsheet into which the data will be inserted (default: None)
    • force_csv - A boolean stating whether to force CSV output (default: False)
    • header_font - The font to be applied to the header row of the spreadsheet; must be an instance of openpyxl.styles.Font (default: None)
    • data_font - The font to be applied to all data cells in the spreadsheet; must be an instance of openpyxl.styles.Font (default: None)
  • excel_response.views.ExcelMixin

  • excel_response.views.ExcelView


Function-based views

You can construct your data from a queryset.

from excel_response import ExcelResponse

def excelview(request):
    objs = SomeModel.objects.all()
    return ExcelResponse(objs)

Or you can construct your data manually.

from excel_response import ExcelResponse

def excelview(request):
    data = [
        ['Column 1', 'Column 2'],
    return ExcelResponse(data, 'my_data')

Class-based views

These are as simple as import and go!

from excel_response import ExcelView

class ModelExportView(ExcelView):
    model = SomeModel

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for django-excel-response, version 2.0.5
Filename, size File type Python version Upload date Hashes
Filename, size django-excel-response-2.0.5.tar.gz (9.0 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page