import pandas as pd
import os

DB_FILE = 'd:/GPS Manager/Stock MANAGE/database.xlsx'

if os.path.exists(DB_FILE):
    try:
        df = pd.read_excel(DB_FILE, sheet_name='Devices', engine='openpyxl')
        print(f"Total Rows: {len(df)}")
        print("Last 15 rows:")
        print(df.tail(15))
        
        # Check specific recent additions logic
        # Show status breakdown
        print("\nStatus Counts:")
        print(df['Status'].value_counts())
    except Exception as e:
        print(f"Error reading DB: {e}")
else:
    print("Database file not found.")