flask展示Excel

from flask import Flask
import pandas as pd

app = Flask(__name__)

@app.route('/')
def show_excel():
    df = pd.read_excel("./学生信息表.xlsx")
    table_html = df.to_html()
    return f"""
        <html>
            <body>
                <h1>学生信息表</h1>
                <div>{table_html}</div>
            </body>
        </html>
    """

if __name__ == '__main__':
    app.run(host="0.0.0.0")
posted @ 2021-05-31 11:29  该显示昵称已被使用了  阅读(372)  评论(0编辑  收藏  举报