Im having problems sending excel file back to browser in flask

Question

Im trying to send an excel file back to the user's browser in flask. The excel file is created with openpyxl.

@app.route('/test', methods=['GET', 'POST'])
def test():
    if request.method == 'GET':

    ...

        buf = BytesIO()
        wb.save(buf)
        buf.seek(0)
        resp = make_response(buf)
            resp.headers["Content-Disposition"] = "attachment; filename=export.xlsx"
            resp.headers["Content-Type"] = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"

        return resp

Im getting the following error:

TypeError: The view function did not return a valid response. The return type must be a string, dict, tuple, Response instance, or WSGI callable, but it was a BytesIO.

How can i do this, without using BytesIO?

Many thanks in advance

use "send_from_directory" see documentation – Narcisse Doudieu Siewe Oct 11 '19 at 22:43 — Narcisse Doudieu Siewe, Oct 11 '19 at 22:43

score 1 · Answer 1 · answered Oct 12 '19 at 00:20

Try send_file:

from flask import send_file
#...
def test():
    buf = BytesIO()
    # ...
    resp = send_file(buf)
    resp.headers["Content-Disposition"] = "attachment; filename=export.xlsx"
    resp.headers["Content-Type"] = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"

Im having problems sending excel file back to browser in flask

1 Answers1