app/ingestion/excel_reader.py

import pandas as pd

def extract_text_from_excel(path):
    df = pd.read_excel(path)
    rows = []

    for _, row in df.iterrows():
        sentence = ". ".join(
            f"{col} is {row[col]}"
            for col in df.columns
            if pd.notna(row[col])
        )

        if sentence.strip():
            rows.append({
                "text": sentence,
                "metadata": {
                    "source": str(path),
                    "type": "excel_row"
                }
            })

    return rows