Python基于openpyxl模块对Excel合并单元格的处理:
#!/usr/bin/env python
# coding=utf-8
import openpyxl
excelFile = 'test.xlsx'
wb = openpyxl.load_workbook(excelFile)
sheet = wb.sheetnames
# 遍列Excel表中所有合并单元格
sh = wb[sheet[0]]
print(sh.merged_cells.ranges)
# [<CellRange A2:A5>, <CellRange A6:A9>, <CellRange A10:A11>]
for item in sh.merged_cells:
print(item)
sh.unmerge_cells(str(item)) #取消单元格合并
# ----------------------------------------------------------------------------------------
# 运行结果:
# [<CellRange A2:A5>, <CellRange A6:A9>, <CellRange A10:A11>]
# A2:A5
# A6:A9
# A10:A11