我想在 flask 里返回 pandas 生成的 Excel 表格, 但又不想保存这个文件 有没有办法,跳过生成文件这个步骤? 我想到用流处理,但不知道该怎么弄

修改完后代码

def download_excel():
    try:
        logger.info('download_excel, %s' % str(request.form))
        form_data = json.loads(request.form.get('data'))
        header_names = form_data['header_names']
        headers = form_data['headers']
        rows = form_data['list']
        data = OrderedDefault(list)
        for row in rows:
            for i, header_name in enumerate(header_names):
                header = headers[i]
                data[header_name].append(row[header])
        bf = io.BytesIO()
        pd.DataFrame(data).to_excel(bf, index=False)
        logger.info('Excel file size: {}'.format(bf.tell()))
        bf.seek(0)
        return send_file(bf, mimetype='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')

    except Exception as e:
        logger.exception(e)
        return make_response('Error', 301)