Breaking News: Grepper is joining You.com. Read the official announcement!

create xlsx file and send without saving it flask

uzii answered on January 4, 2023 Popularity 1/10 Helpfulness 8/10

answer create xlsx file and send without saving it flask

create xlsx file and send without saving it flask

Comment

Here is the code snippet to send the xlsx file without saving it on the server

import io

from flask import Response
from xlsxwriter import Workbook
from  werkzeug.wsgi import FileWrapper

@app.route('/page', methods=['GET', 'POST'])
def func():
    file = io.BytesIO()

    wb = Workbook(file)
    ws = wb.add_worksheet()
    ws.write('A1', 'Hello World')
    wb.close()

    file.seek(0)
    wrapped_file = FileWrapper(file)

    return Response(
        wrapped_file,
        mimetype='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
        direct_passthrough=True,
    )

Popularity 1/10 Helpfulness 8/10 Language javascript

Source: Grepper

Tags: file flask javascript send xlsx

Link to this answer
Share Copy Link

Contributed on Jan 04 2023

uzii

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

create xlsx file and send without saving it flask

Contents

More Related Answers

create xlsx file and send without saving it flask

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.