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

 

    /**
    * @Description: 判断单元格是否是合并单元格
    * @Author: fw
    * @Date: 2019/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);

    }