获取合并单元格中值的一个方法POI

 

    private static String getCellValueForMerginRegion(Cell cell) {
        
        int rowIdx=cell.getRowIndex();
        Sheet sheet=cell.getSheet();
        int mergedRegions=sheet.getNumMergedRegions();
        for (int i = 0; i < mergedRegions; i++) {
            CellRangeAddress cellRangeAddress=sheet.getMergedRegion(i);
            
            if (cellRangeAddress.getLastColumn()==0) {
                int firstRowIdx=cellRangeAddress.getFirstRow();
                int lastRowIdx=cellRangeAddress.getLastRow();
                if (rowIdx<=lastRowIdx&&rowIdx>=firstRowIdx) {
                    String cellValue = null;
                    for (int j = firstRowIdx; j <=lastRowIdx; j++) {
                        cellValue=getCellValue(sheet.getRow(j).getCell(0));
                        if (cellValue.trim().length()==0) {
                            System.out.println("firstRowIdx:"+firstRowIdx+",lastRowIdx:"+lastRowIdx+":"+cellValue);
                            continue;
                        }
                        break;
                    }
                    
                    return cellValue;
                }
            }
            
            
        }
        
        
        return null;
    }