public static boolean isMergedRow(Sheet sheet, int row, int column) {
int sheetMergeCount = sheet.getNumMergedRegions();
for (int i = 0; i < sheetMergeCount; i++) {
CellRangeAddress range = sheet.getMergedRegion(i);
int firstCol = range.getFirstColumn();
int lastCol = range.getLastColun();
int firstRoww = range.getFirstRow();
int lastRow = range.getLastRow();
if (row >= firstRow && row <= lastRow) {
if (column >= firstCol && column <= lastCol) {
return true;
}
}
}
return false;
}
java判断当前excel单元格是否合并
最新推荐文章于 2024-05-14 10:58:35 发布