python flask暂存上传的excel表格文件

• 通过flask其服务的形式，完成excel文件上传操作，并分析其数据（这里是暂存操作）
• python代码

import json
import os
import xlrd
from flask import Flask, request
import xlsxwriter

app = Flask(__name__)
app.config['JSON_AS_ASCII'] = False


@app.route("/file", methods=["POST"])
def save_file2():
    
    DIR = './file_save/'  # 文件保存目录
    
    try:
        print(request.files)
        file = request.files['file']
        print('file', type(file), file)
        print(file.filename)    # 打印文件名
        f = file.read()    #文件内容
        book = xlrd.open_workbook(file_contents=f)
        sheet1 = book.sheets()[0]
        nrows = sheet1.nrows
        print('表格总行数',nrows)
        ncols = sheet1.ncols
        print('表格总列数',ncols)

        # 写文件
        res_name = DIR + file.filename
        workbook = xlsxwriter.Workbook(res_name)
        booksheet = workbook.add_worksheet('Sheet1')

        for i in range(nrows):
            one = sheet1.row_values(i)
            booksheet.write_row("A" + str(i+1), one)
        workbook.close()
        print(res_name, 'ok...')

        return {'code': 1, 'msg': '文件已保存', 'data': '行数为 ' + str(nrows)}
    except Exception:
        return {'code': 0, 'msg': '请检查编码或文件后缀是否为xlsx', 'data': ''}


if __name__ == '__main__':
    app.run(host="0.0.0.0", port=22356)

• postman中操作为