import pandas as pd
import json

file_path = '../doc/KKCT JULI 2026-2.xlsx'
sheet_name = 'JULI 26'

try:
    df = pd.read_excel(file_path, sheet_name=sheet_name, header=None)
    
    # Print the first 10 rows to understand the headers (which might be multi-row)
    print("--- FIRST 10 ROWS ---")
    for i in range(10):
        row = df.iloc[i].fillna('').tolist()
        # Only print rows that have some content
        if any(str(x).strip() for x in row):
            print(f"Row {i}: {row[:30]}") # Print up to column AD
            
    print("\n--- DATA DIMENSIONS ---")
    print(f"Total Rows: {len(df)}")
    print(f"Total Columns: {len(df.columns)}")
except Exception as e:
    print(f"Error: {e}")