合并单元格读取

1
2
3
4
5
6
7
8
9

import xlrd

file = 'demo.xls'

work_book = xlrd.open_workbook(file, formatting_info=True)
work_sheet = work_book.sheet_by_index(0)

print(sheet.merged_cells)
# List[Tuple(row_start, row_end, col_start, col_end)]

注意： index 是半开半闭区间 [row_start, row_end)

参考： API Reference — xlrd 2.0.1 documentation