Menixis's picture
Update app.py
e745eed verified
Raw History Blame Contribute Delete
923 Bytes
import os
import time
from io import BytesIO
import gradio as gr
import pandas as pd
import requests
EXCEL_URL = os.environ.get("EXCEL_URL")
def load_data():
if not EXCEL_URL:
return pd.DataFrame({"error": ["EXCEL_URL secret is not set"]})
try:
r = requests.get(
f"{EXCEL_URL}&t={int(time.time())}",
headers={"Cache-Control": "no-cache", "Pragma": "no-cache"},
timeout=30,
)
r.raise_for_status()
return pd.read_excel(BytesIO(r.content))
except Exception as e:
return pd.DataFrame({"error": [str(e)]})
with gr.Blocks(title="Excel Viewer") as demo:
gr.Markdown("# ๐Ÿ“Š Excel Data Viewer")
gr.Markdown("Data is pulled live from OneDrive. Click Refresh to re-fetch.")
table = gr.Dataframe(value=load_data(), interactive=False, wrap=True)
gr.Button("๐Ÿ”„ Refresh").click(load_data, outputs=table)
demo.launch()