12 lines
667 B
Python
12 lines
667 B
Python
import openpyxl
|
|
|
|
wb = openpyxl.load_workbook("/workspace/personal/blu/SKP_Budget.xlsx", data_only=True)
|
|
ws = wb["Blue Record"]
|
|
|
|
print("=== CHECKING ALL RETURNS IN BLUE RECORD ===")
|
|
for r_idx, row in enumerate(ws.iter_rows(values_only=True), start=1):
|
|
row_str = " ".join([str(c) for c in row if c is not None])
|
|
if any(k in row_str for k in ["برگشت", "عودت", "ناموفق", "اصلاح", "استرداد"]):
|
|
print(f"Row {r_idx}: {row_str[:150]}")
|
|
elif any(k in row_str for k in ["شهلائ", "شهاب", "باقری", "امیرحسین باقری", "عفریته", "افریته"]):
|
|
print(f"[MATCH] Row {r_idx}: {row_str[:150]}")
|