首先是 python3.7的安裝?
防止報錯先安裝幾個編譯必須的組件
yum install gcc patch libffi-devel? python-devel? zlib-devel? bzip2-devel? openssl-devel? ncurses-devel? sqlite-devel? readline-devel? tk-devel? gdbm-devel? db4-devel? libpcap-devel? xz-devel? ?automake? autoconf? libtool? make? ?-y
下載源碼包光坝，自己決定下載的版本我這里用3.7.0
wget? https://www.python.org/ftp/python/3.7.0/Python-3.7.0.tgz
解壓
tar -zxvf? Python-3.7.0.tgz
新建python3目錄
mkdir /usr/local/python3
配置編譯python3
cd Python-3.7.0
./configure --prefix=/usr/local/python3
make && make install
建立軟連接
ln -s /usr/local/python3/bin/python3.7? /usr/bin/python3
ln -s /usr/local/python3/bin/pip3.7? /usr/bin/pip3
我的數(shù)據(jù)庫是PGSQL所以用psycopg2這個網(wǎng)上教程很多不贅述谒拴，與前端交互方法很多這邊用到flask_excel庫七问。
主要講下Flask-Excel的使用
pip install Flask-Excel
或者
git clone https://github.com/pyexcel-webwares/Flask-Excel.git
$cd Flask-Excel
$ python setup.py install
上面安裝完成后按需安裝下面需要的依賴庫
pip install pyexcel-xls
pip install pyexcel-xlsx?
pip install pyexcel-ods
---------------------------------------------------------------------------------------------
#接下來就可以用了
#!/usr/bin/python
#?-*-?coding:?utf-8?-*-
import flask_excel as? excel?
#注意從0.0.7 版以上開始需要init_excel （app ）
@app.route("/download",methods='GET'])
def? download_file():
????????return? excel.make_response_from_array(
? ? ? ? ? ? ? ? ? ? ? ?這里是需要寫入的數(shù)據(jù)列表,
????????????????????????"xlsx",
????????????????????????u"保存文檔名.xlsx"
????????????????????????)
if?__name__?==?'__main__':
????excel.init_excel(app)
????app.run(debug=True,host='127.0.0.1')
還有很多強大的用法下面官方鏈接里面有
官方文檔地址：
https://flask-excel.readthedocs.io/en/latest/#flask_excel.make_response_from_query_sets
