本文整理了Java中org.apache.poi.ss.usermodel.Sheet.removeMergedRegion()方法的一些代码示例，展示了Sheet.removeMergedRegion()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Sheet.removeMergedRegion()方法的具体详情如下：
包路径：org.apache.poi.ss.usermodel.Sheet
类名称：Sheet
方法名：removeMergedRegion

Sheet.removeMergedRegion介绍

[英]Removes a merged region of cells (hence letting them free)
[中]删除合并的单元格区域（从而释放它们）

代码示例

代码示例来源：origin: SheetJS/jxls

/**
 * Removes merged region from sheet
 *
 * @param sheet
 * @param region
 */
public static void removeMergedRegion(Sheet sheet,
    CellRangeAddress region) {
  int index = getMergedRegionIndex(sheet, region);
  if (index >= 0) {
    sheet.removeMergedRegion(index);
  }
}

代码示例来源：origin: net.sf.jxls/jxls-core

/**
 * Removes merged region from sheet
 *
 * @param sheet
 * @param region
 */
public static void removeMergedRegion(Sheet sheet,
    CellRangeAddress region) {
  int index = getMergedRegionIndex(sheet, region);
  if (index >= 0) {
    sheet.removeMergedRegion(index);
  }
}

代码示例来源：origin: net.sf.jxls/jxls-core

public static boolean removeMergedRegion(Sheet sheet, int rowNum,
    int cellNum) {
  Set mergedRegionNumbersToRemove = new TreeSet();
  for (int i = 0, c = sheet.getNumMergedRegions(); i < c; i++) {
    CellRangeAddress merged = getMergedRegion(sheet, i);
    if (isRangeContainsCell(merged, rowNum, cellNum)) {
      mergedRegionNumbersToRemove.add(i);
    }
  }
  for (Iterator iterator = mergedRegionNumbersToRemove.iterator(); iterator.hasNext();) {
    Integer regionNumber = (Integer) iterator.next();
    sheet.removeMergedRegion(regionNumber.intValue());
  }
  return !mergedRegionNumbersToRemove.isEmpty();
}

代码示例来源：origin: SheetJS/jxls

public static boolean removeMergedRegion(Sheet sheet, int rowNum,
    int cellNum) {
  Set mergedRegionNumbersToRemove = new TreeSet();
  for (int i = 0, c = sheet.getNumMergedRegions(); i < c; i++) {
    CellRangeAddress merged = getMergedRegion(sheet, i);
    if (isRangeContainsCell(merged, rowNum, cellNum)) {
      mergedRegionNumbersToRemove.add(i);
    }
  }
  for (Iterator iterator = mergedRegionNumbersToRemove.iterator(); iterator
      .hasNext();) {
    Integer regionNumber = (Integer) iterator.next();
    sheet.removeMergedRegion(regionNumber.intValue());
  }
  return !mergedRegionNumbersToRemove.isEmpty();
}

代码示例来源：origin: org.jxls/jxls-poi

@Override
public void resetArea(AreaRef areaRef) {
  // removing merged regions
  Sheet destSheet = workbook.getSheet(areaRef.getSheetName());
  int numMergedRegions = destSheet.getNumMergedRegions();
  for (int i = numMergedRegions; i > 0; i--) {
    destSheet.removeMergedRegion(i - 1);
  }
}

代码示例来源：origin: openl-tablets/openl-tablets

@Override
public void removeMergedRegion(int x, int y) {
  Sheet sheet = getSheet();
  getMergedRegionsPool().remove(x, y);
  int nregions = getNumberOfMergedRegions();
  for (int i = 0; i < nregions; i++) {
    CellRangeAddress reg = PoiExcelHelper.getMergedRegionAt(i, sheet);
    if (reg.getFirstColumn() == x && reg.getFirstRow() == y) {
      sheet.removeMergedRegion(i);
      return;
    }
  }
}

代码示例来源：origin: org.jxls/jxls-poi

private void findAndRemoveExistingCellRegion(CellRef cellRef) {
  Sheet destSheet = workbook.getSheet(cellRef.getSheetName());
  int numMergedRegions = destSheet.getNumMergedRegions();
  for (int i = 0; i < numMergedRegions; i++) {
    CellRangeAddress mergedRegion = destSheet.getMergedRegion(i);
    if (mergedRegion.getFirstRow() <= cellRef.getRow() && mergedRegion.getLastRow() >= cellRef.getRow() &&
        mergedRegion.getFirstColumn() <= cellRef.getCol() && mergedRegion.getLastColumn() >= cellRef.getCol()) {
      destSheet.removeMergedRegion(i);
      break;
    }
  }
}