用ajax下载flask excel

from flask import Flask, make_response
import pandas as pd

app = Flask(__name__)

@app.route('/download_excel', methods=['GET'])
def download_excel():
    # 生成Excel文件
    data = {'Name': ['John', 'Mike', 'Sarah'], 'Age': [25, 30, 28]}
    df = pd.DataFrame(data)
    excel_file = df.to_excel()

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

function downloadExcel() {
    $.ajax({
        url: '/download_excel',
        type: 'GET',
        success: function(response) {
            // 在这里可以对返回的Excel文件进行处理或下载
        },
        error: function(error) {
            console.log(error);
        }
    });
}