POI 3.17版本 XSSF 获取指定单元格excel合并列数
/**
* @param cell
* @param sheet
*/
public static int getMergeColumnNum(XSSFCell cell, XSSFSheet sheet) {
int mergeSize = 1;
List<CellRangeAddress> mergedRegions = sheet.getMergedRegions();
for (CellRangeAddress cellRangeAddress : mergedRegions) {
if (cellRangeAddress.isInRange(cell.getRowIndex(), cell.getColumnIndex())) {
//获取合并的列数
mergeSize = cellRangeAddress.getLastColumn() - cellRangeAddress.getFirstColumn() + 1;
break;
}
}
return mergeSize;
}