flask 从前端获取excel ，将数据存入数据库_flask 读取excel

flask 从前端获取excel ，将数据存入数据库
前端页面代码展示

<form action="/toexcel" method="post" enctype="multipart/form-data">
           {% if session['role'] == 2 %}
       <li><input type="file" name="file" value="请上传Excel文件"/></li>
       <li><input type="submit" value="导入" class="btn_search"></li>
              {% endif %}
1
2
3
4
5

后台代码展示

@app.route('/toexcel',methods = ['GET','POST'])
def toExcel():
    if request.method == 'POST':
        file = request.files.get('file')
        f = file.read()
        clinic_file = xlrd.open_workbook(file_contents=f)
        # sheet1
        table = clinic_file.sheet_by_index(0)
        nrows = table.nrows
        for i in range(1, nrows):
            row_date = table.row_values(i)
            print(row_date)
            new = News(row_date[1],row_date[2],row_date[3],row_date[4],row_date[5])
            db.session.add(new)

        db.session.commit()
        db.session.close()
        return redirect('/all')
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18