from openpyxl import load_workbook
from datetime import datetime

FILE_NAME = "invoice.xlsx"   # keep SIMPLE name as you said

wb = load_workbook(FILE_NAME, data_only=True)

print(f"Workbook loaded: {FILE_NAME}")
print(f"Total sheets: {len(wb.worksheets)}")

for si, ws in enumerate(wb.worksheets, start=1):
    print("\n" + "=" * 60)
    print(f"SHEET {si}: {ws.title}")
    print("=" * 60)

    print("---- TOP AREA (Rows 1–20, Cols 1–12) ----")
    for r in range(1, 21):
        for c in range(1, 13):
            val = ws.cell(row=r, column=c).value
            if val not in (None, ""):
                print(f"Row {r}, Col {c} -> {val} ({type(val).__name__})")

    print("\n---- BOTTOM AREA (Last 20 rows, Cols 1–12) ----")
    start_row = max(1, ws.max_row - 20)
    for r in range(start_row, ws.max_row + 1):
        for c in range(1, 13):
            val = ws.cell(row=r, column=c).value
            if val not in (None, ""):
                print(f"Row {r}, Col {c} -> {val} ({type(val).__name__})")

print("\nDEBUG COMPLETE")