Python读取Excel例子

使用到flask和pandas

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")