flask接口下载excel表格

服务器保存excel地址

data = {}
dirpath = os.path.join(os.getcwd(), "ReportFiles")
if not dirpath:
   os.makedirs(dirpath)
data["url"] = os.path.join(os.getcwd(), "report.xlsx")
data["json_data"] = report_json   ##(excel报表数据)

接口代码

@app.route("/download/<directory>/<filename>", methods=['GET'])
def download_file(directory,filename):
    """
    下载excel表主服务
    :param directory: 文件夹
    :param filename: 文件名字
    :return:
    """
    # 需要知道2个参数, 第1个参数是本地目录的path, 第2个参数是文件名(带扩展名)
    directory_path = os.getcwd() + "/" + directory  # 假设在当前目录
    return send_from_directory(directory_path, filename, as_attachment=True)



@app.route("/api/download_report", methods=['POST'])
def download_report():
     ""
    生成下载excel表的链接
    :return:
    """
    report = {}
    report ["download_url"] = "http://服务器地址(IP或域名):端口" + str(data["url"].replace("\\","/"))
    return jsonify(data))