import pandas as pd
import os

file_path = r"C:\Projects Dashboard\config\LODOSO.xlsx"

# 1. Confirm file exists
print("File exists:", os.path.exists(file_path))

# 2. Load Excel object (THIS was missing)
xls = pd.ExcelFile(file_path)
df = pd.read_excel(r"C:\Projects Dashboard\config\LODOSO.xlsx",sheet_name="Project Stocktaking Template",header=None)


# Set first row as header
df.columns = df.iloc[0]

# Drop the header row from data
df = df.iloc[1:].reset_index(drop=True)
df.columns = (
    df.columns
      .str.strip()
      .str.lower()
      .str.replace(" ", "_")
)

print(df.head())
print(df.dtypes)