基于Openpyxl模块对Excle合并单元格的处理

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