flask内存中写入excel并返回

from flask import Flask, make_response
from io import BytesIO
import xlwt

app = Flask(__name__)


@app.route('/excel')
def download_excel():
    buffer = BytesIO()

    workbook = xlwt.Workbook(encoding='utf-8')
    sheet = workbook.add_sheet('sheet1')
    sheet.write(0, 0, 'something')

    workbook.save(buffer)

    res = make_response(buffer.getvalue())
    res.headers['Content-Disposition'] = 'attachment; filename=ttt.xls'
    res.headers['Content-Type'] = 'application/x-xls'
    return res


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