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;
}