import openpyxl, sys, io
sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8', errors='replace')
for p in [r"D:\workbbbbbb\workb\杭州机构表.xlsx", r"D:\workbbbbbb\workb\人员信息表.xlsx"]:
    print("="*70)
    print(p)
    wb = openpyxl.load_workbook(p, data_only=True)
    for ws in wb.worksheets:
        print(f"-- sheet: {ws.title!r} dims={ws.dimensions} max_row={ws.max_row} max_col={ws.max_column} merged={len(ws.merged_cells.ranges)}")
        for r in ws.iter_rows(min_row=1, max_row=min(ws.max_row, 40), values_only=True):
            print(r)