如何在flask中创建excel文件并从服务器端发送到客户端

pip install openpyxl

from flask import Flask, send_file
from openpyxl import Workbook
from openpyxl.utils import get_column_letter

app = Flask(__name__)

@app.route('/download_excel')
def download_excel():
    # 创建一个工作簿
    wb = Workbook()
    # 选择默认的活动工作表
    ws = wb.active

    # 向工作表中添加数据
    data = [
        ['姓名', '年龄', '性别'],
        ['张三', 25, '男'],
        ['李四', 30, '女'],
        ['王五', 28, '男']
    ]

    for row in data:
        ws.append(row)

    # 设置列宽
    for col in ws.columns:
        max_length = 0
        column = col[0].column_letter  # 获取列字母
        for cell in col:
            try:
                if len(str(cell.value)) > max_length:
                    max_length = len(cell.value)
            except:
                pass
        adjusted_width = (max_length + 2) * 1.2
        ws.column_dimensions[column].width = adjusted_width

    # 保存工作簿
    wb.save('excel_file.xlsx')

    # 发送文件到客户端
    return send_file('excel_file.xlsx', as_attachment=True)