export-to-excel.py

from django.http import HttpResponse
from openpyxl import Workbook
from openpyxl.writer.excel import save_virtual_workbook

def home_page(request):
    wb = Workbook()
    ws = wb.active
    ws.append(['First Name', 'Last Name'])

    data = [{
        'first_name': 'John',
        'last_name': 'Doe'
    },
    {
        'first_name': 'Matt',
        'last_name': 'Levy'
    }]

    for record in data:
        ws.append([record['first_name'], record['last_name']])

    response = HttpResponse(content=save_virtual_workbook(wb), content_type='application/ms-excel')
    response['Content-Disposition'] = 'attachment; filename=myexport.xlsx'

    return response