使用openpyxl定位合并单元格的当前区域

import openpyxl

workbook = openpyxl.load_workbook('your_file.xlsx')

worksheet = workbook['your_sheet']

merged_cells_ranges = worksheet.merged_cells.ranges

current_cell = 'A1'  # 当前单元格的位置
for merged_range in merged_cells_ranges:
    if current_cell in merged_range:
        merged_range_address = merged_range.coord  # 合并单元格的坐标
        break

merged_range_start, merged_range_end = merged_range_address.split(':')
current_range = worksheet[merged_range_start:merged_range_end]