OpenClaw
79 lines
3.3 KiB
Python
79 lines
3.3 KiB
Python
import openpyxl
|
|
from datetime import datetime
|
|
|
|
datei = "Kopie von Kostenrechnung der Nächsten jahre (3).xlsx"
|
|
print(f"Lade {datei}...")
|
|
|
|
wb = openpyxl.load_workbook(datei, data_only=True)
|
|
ws = wb["Tilgung bei Gleichbleibenden Be"]
|
|
|
|
# Zeile 1 vollständig lesen
|
|
row1 = list(ws.iter_rows(min_row=1, max_row=1, values_only=True))[0]
|
|
row2 = list(ws.iter_rows(min_row=2, max_row=2, values_only=True))[0]
|
|
|
|
print("\n=== ALLE SPALTEN (1-40) ===")
|
|
for i in range(40):
|
|
val1 = row1[i] if i < len(row1) and row1[i] else ""
|
|
val2 = row2[i] if i < len(row2) and row2[i] else ""
|
|
if val1 or val2:
|
|
print(f" Spalte {i+1:2}: '{val1}' | '{val2}'")
|
|
|
|
# Suche nach allen Kredit-Namen (auch in späteren Spalten)
|
|
suchbegriffe = ["Carola", "Kerstin", "PVCreditplus", "PV Creditplus", "Creditplus", "Zingelstr"]
|
|
|
|
print("\n=== SUCHE NACH FEHLENDEN KREDITEN ===")
|
|
for col_idx, cell in enumerate(row1, 1):
|
|
if cell and isinstance(cell, str):
|
|
for suchwort in suchbegriffe:
|
|
if suchwort.lower() in cell.lower():
|
|
print(f" Gefunden '{cell}' bei Spalte {col_idx}, Header: {row2[col_idx-1] if col_idx-1 < len(row2) else 'N/A'}")
|
|
|
|
# Sparkasse genauer prüfen - vielleicht ist es in Spalte 23?
|
|
print("\n=== SPARKASSE DETAILS ===")
|
|
print("Spalte 21 Header:", row2[20] if len(row2) > 20 else "N/A")
|
|
print("Spalte 22 Header:", row2[21] if len(row2) > 21 else "N/A")
|
|
print("Spalte 23 Header:", row2[22] if len(row2) > 22 else "N/A")
|
|
|
|
# Prüfe Zeile 1 bei Spalte 23
|
|
print("Spalte 21 Name:", row1[20] if len(row1) > 20 else "N/A")
|
|
print("Spalte 22 Name:", row1[21] if len(row1) > 21 else "N/A")
|
|
print("Spalte 23 Name:", row1[22] if len(row1) > 22 else "N/A")
|
|
|
|
# Suche nach "Sparkasse" in Zeile 1
|
|
for col_idx, cell in enumerate(row1, 1):
|
|
if cell and isinstance(cell, str) and "sparkasse" in cell.lower():
|
|
print(f"\nSparkasse bei Spalte {col_idx}: '{cell}'")
|
|
# Nächste 3 Spalten zeigen
|
|
for i in range(col_idx-1, min(col_idx+2, len(row2))):
|
|
print(f" Spalte {i+1}: Name='{row1[i]}', Header='{row2[i]}'")
|
|
|
|
# Suche nach "Carola"
|
|
for col_idx, cell in enumerate(row1, 1):
|
|
if cell and isinstance(cell, str) and "carola" in cell.lower():
|
|
print(f"\nCarola bei Spalte {col_idx}: '{cell}'")
|
|
for i in range(col_idx-1, min(col_idx+3, len(row2))):
|
|
print(f" Spalte {i+1}: Name='{row1[i]}', Header='{row2[i]}'")
|
|
|
|
# Suche nach "Kerstin"
|
|
for col_idx, cell in enumerate(row1, 1):
|
|
if cell and isinstance(cell, str) and "kerstin" in cell.lower():
|
|
print(f"\nKerstin bei Spalte {col_idx}: '{cell}'")
|
|
for i in range(col_idx-1, min(col_idx+3, len(row2))):
|
|
print(f" Spalte {i+1}: Name='{row1[i]}', Header='{row2[i]}'")
|
|
|
|
# Suche nach "PVCreditplus" oder "Creditplus"
|
|
for col_idx, cell in enumerate(row1, 1):
|
|
if cell and isinstance(cell, str):
|
|
if "credit" in cell.lower() or "pvc" in cell.lower() or "plus" in cell.lower():
|
|
print(f"\nCredit/Plus bei Spalte {col_idx}: '{cell}'")
|
|
for i in range(col_idx-1, min(col_idx+3, len(row2))):
|
|
print(f" Spalte {i+1}: Name='{row1[i]}', Header='{row2[i]}'")
|
|
|
|
# Suche nach Zahlungen/Zinsen in Spalte 22-30
|
|
print("\n=== SPALTEN 27-35 ===")
|
|
for i in range(26, 35):
|
|
if i < len(row1):
|
|
val1 = row1[i] if row1[i] else ""
|
|
val2 = row2[i] if i < len(row2) and row2[i] else ""
|
|
print(f" Spalte {i+1:2}: '{val1}' | '{val2}'")
|