如何在不打开窗口的情况下下载excel电子表格

import openpyxl
from flask import Flask, make_response

app = Flask(__name__)

@app.route('/download_excel', methods=['GET'])
def download_excel():
    # 创建一个Excel工作簿
    workbook = openpyxl.Workbook()
    sheet = workbook.active

    # 在表格中写入数据
    sheet['A1'] = '姓名'
    sheet['B1'] = '年龄'
    sheet['A2'] = '张三'
    sheet['B2'] = 25
    sheet['A3'] = '李四'
    sheet['B3'] = 30

    # 保存Excel文件到内存中
    excel_data = openpyxl.writer.excel.save_virtual_workbook(workbook)

    # 构建响应对象
    response = make_response(excel_data)
    response.headers['Content-Type'] = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
    response.headers['Content-Disposition'] = 'attachment; filename=example.xlsx'

    return response

if __name__ == '__main__':
    app.run()