19 lines
833 B
Python
19 lines
833 B
Python
import openpyxl
|
|
|
|
wb = openpyxl.load_workbook("/workspace/personal/blu/SKP_Budget.xlsx", data_only=True)
|
|
keywords = ["شهاب", "شهلائ", "عفریته", "افریته", "آنلاک", "زردخشو", "1920", "نوزده بیست", "کرمانشاه", "محمدی"]
|
|
|
|
print("=== SEARCHING ALL SHEETS IN SKP_BUDGET.XLSX ===")
|
|
for sheetname in wb.sheetnames:
|
|
ws = wb[sheetname]
|
|
matches = []
|
|
for row_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])
|
|
for kw in keywords:
|
|
if kw in row_str:
|
|
matches.append((row_idx, row_str))
|
|
break
|
|
if matches:
|
|
print(f"\nSheet [{sheetname}]: {len(matches)} matches")
|
|
for m in matches[:15]:
|
|
print(f" Row {m[0]}: {m[1][:150]}")
|