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 读取merged cell 值所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。