POI获取指定元素的合并单元格数

POI获取指定元素的合并单元格数

如下：

public static int GetMergeNum(Cell cell, Sheet sheet) {
	int mergeSize = 1;
	List<CellRangeAddress> mergedRegions = sheet.getMergedRegions();
	for (CellRangeAddress cellRangeAddress : mergedRegions) {
		if (cellRangeAddress.isInRange(cell)) {				
		//获取合并的行数
		mergeSize = cellRangeAddress.getLastColumn() - cellRangeAddress.getFirstColumn() + 1;
		//获取合并的列数
		//mergeSize =	cellRangeAddress.getFirstRow()-cellRangeAddress.getLastRow()+1；			
			break;
		}
	}
	return mergeSize;
}