from flask import Flask, jsonify
import pandas as pd

app = Flask(__name__)

# Load the Excel data
data = pd.ExcelFile('Digital_Marketing_Metrics_Template_Final.xlsx')

def load_data():
    # Read each sheet into a dictionary
    return {sheet: data.parse(sheet).to_dict(orient='records') for sheet in data.sheet_names}

@app.route('/')
def home():
    return '<h1>Welcome to the Dashboard</h1><p>Use /data to view metrics</p>'

@app.route('/data')
def get_data():
    return jsonify(load_data())

if __name__ == '__main__':
    app.run()