openpyxl - 一些简单用法

一些简单用法

---

合并/取消合并单元格

>>> from openpyxl.workbook import Workbook>>>>>> wb = Workbook()>>> ws = wb.active>>>>>> ws.merge_cells('A1:B1')>>> ws.unmerge_cells('A1:B1')>>>>>> # 以下函数可以达到相同效果>>> ws.merge_cells(start_row=2,start_column=1,end_row=2,end_column=4)>>> ws.unmerge_cells(start_row=2,start_column=1,end_row=2,end_column=4)