{"id":629,"date":"2020-02-22T17:43:56","date_gmt":"2020-02-22T09:43:56","guid":{"rendered":"http:\/\/cnliutz.uicp.io\/wordpress\/?p=629"},"modified":"2020-02-23T18:06:01","modified_gmt":"2020-02-23T10:06:01","slug":"python%e8%af%bb%e5%8f%96excel%e5%b1%95%e7%a4%ba%e5%9c%a8%e7%bd%91%e9%a1%b5%e4%b8%8a","status":"publish","type":"post","link":"http:\/\/g1n29wqq.ipyingshe.net:5347\/?p=629","title":{"rendered":"Python\u8bfb\u53d6excel\u5c55\u793a\u5728\u7f51\u9875\u4e0a"},"content":{"rendered":"\n

from flask import Flask
import pandas as pd
app=Flask(__name__)
@app.route(“\/”)
def show_excel():
df=pd.read_excel(“huizong.xls”)
table_html=df.to_html()
#f in the string ,means have variable in string
return f”’
<html>
<body>
<h1>Excel Data<\/h1>
<dev>{table_html}<\/dev>
<\/body>
<\/html>
”’
if __name__==”__main__”:
app.run(host=”0.0.0.0″,port=9001,debug=True)<\/p>\n\n\n\n

app.py<\/a>\u4e0b\u8f7d<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"

from flask import Flask import pandas as Continue Reading<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,6],"tags":[],"class_list":["post-629","post","type-post","status-publish","format-standard","hentry","category-python","category-6"],"_links":{"self":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/629","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=629"}],"version-history":[{"count":3,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/629\/revisions"}],"predecessor-version":[{"id":632,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/629\/revisions\/632"}],"wp:attachment":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=629"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}