poi获取合并单元格

/** * 获取合并单元格的值 
* @param sheet 
* @param row 
* @param column 
* @return */ 
public String getMergedRegionValue(Sheet sheet, int row, int column) { 
int sheetMergeCount = sheet.getNumMergedRegions(); 
for (int i = 0; i < sheetMergeCount; i++) { 
CellRangeAddress ca = sheet.getMergedRegion(i); 
int firstColumn = ca.getFirstColumn(); 
int lastColumn = ca.getLastColumn(); 
int firstRow = ca.getFirstRow(); 
int lastRow = ca.getLastRow(); 
if (row >= firstRow && row <= lastRow) { 
if (column >= firstColumn && column <= lastColumn) { 
Row fRow = sheet.getRow(firstRow); 
Cell fCell = fRow.getCell(firstColumn); 
return getCellValue(fCell); 
} 
} 
} 
return null; 
}


http://zhaoxian705.blog.163.com/blog/static/54190157201171124242322/

http://wenku.baidu.com/link?url=0bgxOZ0DKgyaZCRIo5400XiBU4SOhHFULW5oxM1Meen1yRQHRmRw4Zn611z_U7aeYGaMqQ16YFy43LSToLSxn3tfPUQlfFlaBZP8xluL52W
http://download.csdn.net/detail/hjhui0708/8499973