Flask 导入和导出

# Flask  导入和导出

## 前端

### 写个按钮
```html
 <button type="button" class="btn" data-toggle="modal" data-target="#addshow" style="margin-left: 2px;"> 服务器添加 </button>
<button type="button" class="btn" data-toggle="modal" data-target="#excelshow">Excel导入服务器</button>
```

### 导入模板
```html
    
   <div class="modal fade" id="excelshow">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h4 class="modal-title">Excel导入服务器</h4>
                </div>
                <div class="modal-body">
                    <p>模板下载：<a href="/servers/getexcel">点击下载Excel模板</a></p>
                    <form action="/servers/insert_from_excel" enctype='multipart/form-data' method='POST'>
                        <div class="form-group">
                            <input type="file" name="servers">
                        </div>
                        <button type="submit" class="btn">上传并导入</button>
                    </form>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">关闭</button>
                </div>
            </div>
        </div>
    </div>
```

---

## 后台参数

### servers.py 导出
```python
from flask import send_from_directory
import tool_excel
import json,os,time
@servers.route('/getexcel')
def getexcel():
    curdir = os.path.dirname(os.path.realpath(__file__))
    return send_from_directory( curdir + "/static/"+"/download", "servers.xlsx", as_attachment=True )
```

### 后台导入
```python
@servers.route('/insert_from_excel', methods=['get', 'post'])
def insert_from_excel():
    f = request.files.get('servers')
    ramname = int(time.time() * 1000)
    f.save('/tmp/{0}'.format( ramname ))
    tool_excel.insertFromExcel( '/tmp/{0}'.format( ramname ) )
    return "Success!"
```

### 定制参数

- Falsk 根目录

> /mnt/

- 下载文件目录

>/mnt/static/download/servers.xlsx

- 临时目录
/tmp/

>1581489830777