apache poi 获取表格合并单元格

可以使用 Apache POI 的 `CellRangeAddress` 类来获取表格中的合并单元格信息。以下是获取合并单元格起始和结束行列号的示例代码：

import org.apache.poi.ss.usermodel.*;

public class ExcelUtils {
  
  public static CellRangeAddress getMergedRegion(Sheet sheet, int row, int column) {
    for (int i = 0; i < sheet.getNumMergedRegions(); i++) {
      CellRangeAddress merged = sheet.getMergedRegion(i);
      if (merged.isInRange(row, column)) {
        return merged;
      }
    }
    return null;
  }
  
  public static int getMergedRegionStartRow(CellRangeAddress merged) {
    return merged.getFirstRow();
  }
  
  public static int getMergedRegionEndRow(CellRangeAddress merged) {
    return merged.getLastRow();
  }
  
  public static int getMergedRegionStartColumn(CellRangeAddress merged) {
    return merged.getFirstColumn();
  }
  
  public static int getMergedRegionEndColumn(CellRangeAddress merged) {
    return merged.getLastColumn();
  }
  
}

使用示例：

Sheet sheet = workbook.getSheetAt(0);
Cell cell = sheet.getRow(1).getCell(1);

// 获取合并单元格信息
CellRangeAddress merged = ExcelUtils.getMergedRegion(sheet, cell.getRowIndex(), cell.getColumnIndex());
if (merged != null) {
  int startRow = ExcelUtils.getMergedRegionStartRow(merged);
  int endRow = ExcelUtils.getMergedRegionEndRow(merged);
  int startColumn = ExcelUtils.getMergedRegionStartColumn(merged);
  int endColumn = ExcelUtils.getMergedRegionEndColumn(merged);
  System.out.println("合并单元格起始行：" + startRow);
  System.out.println("合并单元格结束行：" + endRow);
  System.out.println("合并单元格起始列：" + startColumn);
  System.out.println("合并单元格结束列：" + endColumn);
}