import openpyxl

file_path = 'src/data/Code Search 2024_Shop.xlsx'
print(f"Loading {file_path}...")
wb = openpyxl.load_workbook(file_path, data_only=True)

print(f"Total Sheets: {len(wb.sheetnames)}")
print("Sheet Names:", wb.sheetnames)

for name in wb.sheetnames:
    sheet = wb[name]
    print(f"\n--- {name} ---")
    print(f"Dimensions: {sheet.dimensions}")
    # Print first few rows to identify what this sheet does
    count = 0
    for row in sheet.iter_rows(values_only=True):
        # Filter out completely empty rows
        if not any(row): continue
        
        # Print first 10 columns
        print(row[:10])
        count += 1
        if count >= 10: break