import openpyxl
import os
import json

excel_path = r"c:\fuentes\proyectos delphi\RAUL_ASENCIO\GESTION\documentacion raul asencio\IFS\Formatos de registro\RG-02 Pesado y preparación de ingredientes.xlsx"

wb = openpyxl.load_workbook(excel_path, data_only=True)
print("Hojas disponibles:", wb.sheetnames)

for sheet_name in wb.sheetnames:
    print(f"\n--- HOJA: {sheet_name} ---")
    ws = wb[sheet_name]
    for r in range(1, min(60, ws.max_row + 1)):
        row_vals = [ws.cell(row=r, column=c).value for c in range(1, min(20, ws.max_column + 1))]
        if any(v is not None for v in row_vals):
            # Limpiar celdas vacias al final
            while row_vals and row_vals[-1] is None:
                row_vals.pop()
            print(f"Fila {r:2d}: {row_vals}")