import openpyxl

file_path = 'src/data/Code Search 2024_Shop.xlsx'
wb = openpyxl.load_workbook(file_path, data_only=True) # Read values only to see what's visible

print("Sheets found:", wb.sheetnames)

for sheet in wb:
    print(f"\nSheet: {sheet.title}, Max Row: {sheet.max_row}, Max Col: {sheet.max_column}")
    # Print first few non-empty cells to guess content
    count = 0
    for row in sheet.iter_rows(values_only=True):
        if any(row):
            print(row[:5]) # Print first 5 columns
            count += 1
        if count > 5: break