判断excel表格中某个单元格是否是合并单元格

/*** @Description: 判断单元格是否是合并单元格* @Author: fw* @Date: /12/27 15:09*/public static Result isMergeCell(Sheet sheet, int row, int column){int sheetMergeCount = sheet.getNumMergedRegions();for (int i = 0; i < sheetMergeCount; i++) {CellRangeAddress range = sheet.getMergedRegion(i);int firstColumn = range.getFirstColumn();int lastColumn = range.getLastColumn();int firstRow = range.getFirstRow();int lastRow = range.getLastRow();if(row >= firstRow && row <= lastRow){if(column >= firstColumn && column <= lastColumn){//excel物理行数和我们的逻辑行数不同，所以需要加1显示return new Result(true,firstRow+1,lastRow+1,firstColumn+1,lastColumn+1);};}};return new Result(false,row,row,column,column);}