How to show a table with Tabulator using Flask and a JSON variable

Flask flyf35 — 8 April 2023 · Comments off

Solution

@app.route('/')
def index():
   src = os.path.join(app.config['UPLOAD_FOLDER'], 'file.xlsx')
   df = pd.read_excel(src, engine='openpyxl')
   return render_template('index.html', data=df.to_dict(orient='records')