#!/usr/bin/env python3
import openpyxl
import sys
from datetime import datetime

def read_excel_values(filename):
    """Liest Excel mit berechneten Werten (nicht Formeln)"""
    wb = openpyxl.load_workbook(filename, data_only=True)
    
    print(f"=== Datei: {filename} ===\n")
    print(f"Sheets: {wb.sheetnames}\n")
    
    for sheet_name in wb.sheetnames:
        ws = wb[sheet_name]
        print(f"--- Sheet: {sheet_name} ---")
        print(f"Zeilen: {ws.max_row}, Spalten: {ws.max_column}\n")
        
        print("Alle Zeilen mit Daten (ab Zeile 6 - Header):")
        for row_num, row in enumerate(ws.iter_rows(min_row=6, max_row=ws.max_row, values_only=True), start=6):
            # Filtere leere Zeilen
            if any(cell is not None for cell in row):
                print(f"Zeile {row_num}: {row}")
        print("-" * 80)
    
    wb.close()

if __name__ == "__main__":
    if len(sys.argv) < 2:
        print("Verwendung: python read_excel_values.py <datei.xlsx>")
        sys.exit(1)
    
    read_excel_values(sys.argv[1])