#!/usr/bin/env python3
import csv
from pathlib import Path
from openpyxl import load_workbook

base = Path(r"c:\Users\genge\OneDrive\Desktop\Projet\StageEnvie2e\ExportAccess")
folders = sorted([d for d in base.iterdir() if d.is_dir()])

print(f"Found {len(folders)} folders\n")

for folder in folders:
    xlsx_files = sorted(folder.glob("*.xlsx"))
    
    if not xlsx_files:
        print(f"📁 {folder.name}/ - (no XLSX files)")
        continue
    
    print(f"📁 {folder.name}/ ({len(xlsx_files)} files)")
    
    for xlsx_path in xlsx_files:
        csv_name = xlsx_path.name.replace(".xlsx", ".csv")
        csv_path = folder / csv_name
        
        # Skip if CSV already exists
        if csv_path.exists():
            print(f"   ✓ {xlsx_path.name} → CSV already exists, skip")
            continue
        
        try:
            wb = load_workbook(xlsx_path)
            ws = wb.active
            
            rows = []
            for row in ws.iter_rows(values_only=True):
                rows.append(row)
            
            with csv_path.open("w", encoding="utf-8-sig", newline="") as f:
                writer = csv.writer(f, delimiter=",", quotechar='"', quoting=csv.QUOTE_MINIMAL, lineterminator="\n")
                writer.writerows(rows)
            
            print(f"   ✓ {xlsx_path.name} → {csv_path.name} ({len(rows)} rows)")
        except Exception as e:
            print(f"   ✗ {xlsx_path.name} failed: {e}")

print("\n✅ Done")