将数据写入xls并下载到python-django中

import pandas as pd
from django.http import HttpResponse

def download_xls(request):
    # 假设我们有一些数据要写入Excel
    data = {
        'Name': ['Alice', 'Bob', 'Charlie'],
        'Age': [24, 27, 22],
        'City': ['New York', 'Los Angeles', 'Chicago']
    }
    
    # 将字典转换为Pandas DataFrame
    df = pd.DataFrame(data)
    
    # 创建一个ExcelWriter对象，使用openpyxl引擎
    writer = pd.ExcelWriter('output.xlsx', engine='openpyxl')
    
    # 将DataFrame写入Excel文件
    df.to_excel(writer, index=False, sheet_name='Sheet1')
    
    # 保存并关闭ExcelWriter
    writer.save()
    
    # 读取刚创建的Excel文件
    xls = open('output.xlsx', 'rb')
    
    # 创建一个HttpResponse对象，并设置适当的MIME类型
    response = HttpResponse(xls, content_type='application/vnd.ms-excel')
    response['Content-Disposition'] = 'attachment; filename=output.xlsx'
    
    return response

with pd.ExcelWriter('output.xlsx', engine='openpyxl') as writer:
    df.to_excel(writer, index=False, sheet_name='Sheet1')