from openpyxl import load_workbook wb = load_workbook(filename='XXXXXX.xlsx') for sheet in wb.sheetnames: print('-' * 20) print(sheet) ws = wb[sheet] for i in ws.merged_cells.ranges: if i.min_row != i.max_row: print(i)
from openpyxl import load_workbook wb = load_workbook(filename='XXXXXX.xlsx') for sheet in wb.sheetnames: print('-' * 20) print(sheet) ws = wb[sheet] for i in ws.merged_cells.ranges: if i.min_row != i.max_row: print(i)