flask将MySQL数据存储到csv并返回前端(flask-excel 踩坑)

安装flask-excel

pipi install flask-excel

按照自己的需求修改dome就好了

# dome
from flask import Flask, request, jsonify
import flask_excel as excel

app = Flask(__name__)

@app.route("/download_file_named_in_unicode", methods=['GET'])
def download_file_named_in_unicode():
	data = [["admin", 12], ["root", 18]]    # MySQL数据封装成这样
    return excel.make_response_from_array(data, "csv",
                                          file_name=u"中文文件名"，
										  column_names=[
								         		"用户名",
								         		"年龄"
								         ]  
										)

# insert database related code here
if __name__ == "__main__":
    excel.init_excel(app)       # 网上教程里有些没有这个  需要先初始化在使用
    app.run()