import openpyxl
import json
import sys

def read_excel(file_path):
    try:
        wb = openpyxl.load_workbook(file_path, data_only=True)
        data = {}
        for sheet_name in wb.sheetnames:
            sheet = wb[sheet_name]
            rows = []
            for row in sheet.iter_rows(values_only=True):
                rows.append(row)
            data[sheet_name] = rows
        return data
    except Exception as e:
        return {"error": str(e)}

if __name__ == "__main__":
    file_path = r"C:\xampp\htdocs\New_Stram_Site_web\CDC_STRAM_Suivi_v2.xlsx"
    output_path = r"C:\tmp\cdc_data.json"
    
    result = read_excel(file_path)
    with open(output_path, "w", encoding="utf-8") as f:
        json.dump(result, f, indent=2, ensure_ascii=False)
    print(f"Data written to {output_path}")