OpenClaw
18 lines
767 B
Python
18 lines
767 B
Python
import openpyxl, os, glob
|
|
|
|
base = r'C:\Users\renet\.openclaw\workspace\buchhaltungs-app'
|
|
for f in glob.glob(os.path.join(base, '*.xlsx')):
|
|
try:
|
|
wb = openpyxl.load_workbook(f, data_only=True)
|
|
name = os.path.basename(f)
|
|
print(f'\n=== {name} ===')
|
|
print(f'Sheets: {wb.sheetnames}')
|
|
for sn in wb.sheetnames:
|
|
ws = wb[sn]
|
|
print(f' Sheet "{sn}": {ws.max_row}r x {ws.max_column}c')
|
|
for row in ws.iter_rows(min_row=1, max_row=min(ws.max_row, 50), values_only=False):
|
|
vals = [(c.value, c.coordinate) for c in row if c.value is not None]
|
|
if vals:
|
|
print(f' {vals}')
|
|
except Exception as e:
|
|
print(f'ERROR {os.path.basename(f)}: {e}') |