如何使用Django和Pandas将excel文件返回给用户

pip install django pandas

import pandas as pd
from django.http import HttpResponse

def excel_view(request):
    # 读取Excel文件数据
    data = pd.read_excel('path/to/excel_file.xlsx')

    # 将数据导出为Excel文件
    output = io.BytesIO()
    writer = pd.ExcelWriter(output, engine='xlsxwriter')
    data.to_excel(writer, index=False, sheet_name='Sheet1')
    writer.save()
    output.seek(0)

    # 构建HTTP响应，将Excel文件返回给用户
    response = HttpResponse(content_type='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
    response['Content-Disposition'] = 'attachment; filename="excel_file.xlsx"'
    response.write(output.getvalue())

    return response

from django.urls import path
from . import views

urlpatterns = [
    path('download-excel/', views.excel_view, name='excel_view'),
]