openpyxl 读取merged cell 值

import openpyxl as xl
from openpyxl.worksheet.worksheet import Worksheet
from openpyxl.cell import MergedCell
from openpyxl import Workbook, load_workbook
from openpyxl.cell import MergedCell
from openpyxl.worksheet.cell_range import CellRange


def cell_val(work_sheet, coordinate):
    tmp_cell = work_sheet[coordinate]
    if isinstance(tmp_cell, MergedCell):
        tmp_range = CellRange(min_col=tmp_cell.column, min_row=tmp_cell.row, max_col=tmp_cell.column,
                              max_row=tmp_cell.row)
        for cur_range in work_sheet.merged_cells.ranges:
            if cur_range.issuperset(tmp_range):
                tmp_val = work_sheet.cell(cur_range.min_row, cur_range.min_col).value
                break
    else:
        tmp_val = tmp_cell.value

    return tmp_val

print('E4 -> ', cell_val(sheet_2g, 'E4'))
print('A4 -> ', cell_val(sheet_2g, 'A4'))

最后

以上就是魁梧御姐最近收集整理的关于openpyxl 读取merged cell 值的全部内容，更多相关openpyxl内容请搜索靠谱客的其他文章。