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

HSSFSheet.addMergedRegion介绍

[英]adds a merged region of cells (hence those cells form one)
[中]添加合并的单元格区域（因此这些单元格形成一个区域）

代码示例

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

/**
 * Adds a merged region of cells on a sheet.
 *
 * @param region to merge
 * @return index of this region
 * @throws IllegalArgumentException if region contains fewer than 2 cells
 * @throws IllegalStateException if region intersects with a multi-cell array formula
 * @throws IllegalStateException if region intersects with an existing region on this sheet
 */
@Override
public int addMergedRegion(CellRangeAddress region) {
  return addMergedRegion(region, true);
}

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

/**
 * Adds a merged region of cells (hence those cells form one).
 * Skips validation. It is possible to create overlapping merged regions
 * or create a merged region that intersects a multi-cell array formula
 * with this formula, which may result in a corrupt workbook.
 *
 * To check for merged regions overlapping array formulas or other merged regions
 * after addMergedRegionUnsafe has been called, call {@link #validateMergedRegions()}, which runs in O(n^2) time.
 *
 * @param region to merge
 * @return index of this region
 * @throws IllegalArgumentException if region contains fewer than 2 cells
 */
@Override
public int addMergedRegionUnsafe(CellRangeAddress region) {
  return addMergedRegion(region, false);
}

代码示例来源：origin: stackoverflow.com

cellRangeAddress.getFirstColumn(),
    cellRangeAddress.getLastColumn());
worksheet.addMergedRegion(newCellRangeAddress);

代码示例来源：origin: bill1012/AdminEAP

sheet.addMergedRegion(new CellRangeAddress(startRow, i , colindex, colindex));
  else
    continue;
} else {
  if((i-1)>startRow)
    sheet.addMergedRegion(new CellRangeAddress(startRow, i - 1, colindex, colindex));
  startRow = i;

代码示例来源：origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

/**
 * Adds a merged region of cells on a sheet.
 *
 * @param region to merge
 * @return index of this region
 * @throws IllegalArgumentException if region contains fewer than 2 cells
 * @throws IllegalStateException if region intersects with a multi-cell array formula
 * @throws IllegalStateException if region intersects with an existing region on this sheet
 */
@Override
public int addMergedRegion(CellRangeAddress region) {
  return addMergedRegion(region, true);
}

代码示例来源：origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

/**
 * Adds a merged region of cells (hence those cells form one).
 * Skips validation. It is possible to create overlapping merged regions
 * or create a merged region that intersects a multi-cell array formula
 * with this formula, which may result in a corrupt workbook.
 *
 * To check for merged regions overlapping array formulas or other merged regions
 * after addMergedRegionUnsafe has been called, call {@link #validateMergedRegions()}, which runs in O(n^2) time.
 *
 * @param region to merge
 * @return index of this region
 * @throws IllegalArgumentException if region contains fewer than 2 cells
 */
@Override
public int addMergedRegionUnsafe(CellRangeAddress region) {
  return addMergedRegion(region, false);
}

代码示例来源：origin: qcadoo/mes

private void mergeHeaderCells(final HSSFSheet sheet, int numberOfColumns) {
  sheet.addMergedRegion(new CellRangeAddress(3, 3, 0, numberOfColumns - 1));
  sheet.addMergedRegion(new CellRangeAddress(3, 3, numberOfColumns, 24));
  for (int columnNumber = 0; columnNumber < numberOfColumns; columnNumber++) {
    sheet.addMergedRegion(new CellRangeAddress(4, 5, columnNumber, columnNumber));
  }
}

代码示例来源：origin: qcadoo/mes

private void addHeaderCell(HSSFSheet sheet, String content, HSSFRow headerRow, int columnIndex, int lastColumnIndex,
    StylesContainer stylesContainer) {
  sheet.addMergedRegion(new CellRangeAddress(0, 0, columnIndex, lastColumnIndex));
  createHeaderCell(stylesContainer, headerRow, content, columnIndex, HSSFCellStyle.ALIGN_CENTER);
}

代码示例来源：origin: com.github.hazendaz/displaytag

/**
 * Make a row span the width of the table.
 * @param model The table model representing the rendered table.
 */
private void rowSpanTable(TableModel model)
{
  this.sheet.addMergedRegion(this.getMergeCellsRegion(
    this.currentCell.getColumnIndex(),
    (model.getNumberOfColumns() - 1)));
}

代码示例来源：origin: displaytag/displaytag-export-poi

/**
 * Make a row span the width of the table.
 * @param model The table model representing the rendered table.
 */
private void rowSpanTable(TableModel model)
{
  this.sheet.addMergedRegion(this.getMergeCellsRegion(this.currentCell.getColumnIndex(), (model
    .getNumberOfColumns() - 1)));
}

代码示例来源：origin: qcadoo/mes

private void addDateHeader(HSSFSheet sheet, Locale locale, HSSFRow headerRow, StylesContainer stylesContainer) {
  sheet.addMergedRegion(new CellRangeAddress(0, 1, 0, 0));
  createHeaderCell(stylesContainer, headerRow,
      translationService.translate("materialFlowResource.palletBalance.report.date", locale), 0,
      HSSFCellStyle.ALIGN_CENTER);
}

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

public static void main(String[] args) throws IOException {
    try (HSSFWorkbook wb = new HSSFWorkbook()) {
       HSSFSheet sheet = wb.createSheet("new sheet");

       HSSFRow row = sheet.createRow(1);
       HSSFCell cell = row.createCell(1);
       cell.setCellValue("This is a test of merging");

       sheet.addMergedRegion(new CellRangeAddress(1, 1, 1, 2));

       // Write the output to a file
       try (FileOutputStream fileOut = new FileOutputStream("workbook.xls")) {
         wb.write(fileOut);
       }
    }
  }
}

代码示例来源：origin: qcadoo/mes

private void addSeriesOfReportAuthorAndDate(final HSSFSheet sheet, final Entity report,
    final PPSReportXlsStyleContainer styleContainer) {
  HSSFRow row = sheet.createRow(1);
  HSSFCell updateDateCell = row.createCell(0);
  updateDateCell.setCellValue(updateFormat.format(report.getDateField(PPSReportFields.UPDATE_DATE)));
  HSSFCell authorCell = row.createCell(2);
  authorCell.setCellValue(ppsReportXlsHelper.getDocumentAuthor(report.getStringField(PPSReportFields.CREATE_USER)));
  sheet.addMergedRegion(new CellRangeAddress(1, 1, 0, 1));
  sheet.addMergedRegion(new CellRangeAddress(1, 1, 2, 4));
  ppsReportXlsStyleHelper.setHeaderStyle2(updateDateCell, styleContainer);
  ppsReportXlsStyleHelper.setHeaderStyle2(authorCell, styleContainer);
}

代码示例来源：origin: FenixEdu/fenixedu-academic

protected void addHeaderCell(HSSFSheet sheet, String value, int columnNumber) {
  HSSFRow row = sheet.getRow(0);
  HSSFCell cell = row.createCell(columnNumber);
  cell.setCellValue(value);
  cell.setCellStyle(headerStyle);
  sheet.addMergedRegion(new CellRangeAddress(0, 1, columnNumber, columnNumber));
}

代码示例来源：origin: paypal/SeLion

private void createReportName(HSSFSheet sheet, int rowNum, int iColStart, HSSFCellStyle style) {
  logger.entering(new Object[] { sheet, rowNum, iColStart, style });
  HSSFRow row = sheet.createRow(rowNum);
  HSSFCell newCell;
  int iColEnd = (this.getColTitles().size() > 0) ? (this.getColTitles().size() + iColStart - 1)
      : (iColStart + 1);
  sheet.addMergedRegion(new CellRangeAddress(rowNum, rowNum, iColStart, iColEnd));
  for (int iTempCol = iColStart; iTempCol <= iColEnd; iTempCol++) {
    newCell = row.createCell(iTempCol);
    newCell.setCellStyle(style);
    newCell.setCellValue(this.reportName);
  }
  logger.exiting();
}

代码示例来源：origin: qcadoo/mes

private void createHeaderForAuthor(final HSSFSheet sheet, final Locale locale,
    final PPSReportXlsStyleContainer styleContainer) {
  HSSFRow headerAuthorLine = sheet.createRow(0);
  HSSFCell updateDateCell = headerAuthorLine.createCell(0);
  updateDateCell.setCellValue(translationService.translate(PPSReportConstants.COLUMN_HEADER_UPDATE_DATE, locale));
  HSSFCell authorCell = headerAuthorLine.createCell(2);
  authorCell.setCellValue(translationService.translate(PPSReportConstants.COLUMN_HEADER_AUTHOR, locale));
  sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 1));
  sheet.addMergedRegion(new CellRangeAddress(0, 0, 2, 4));
  ppsReportXlsStyleHelper.setGreyDataStyle(updateDateCell, styleContainer);
  ppsReportXlsStyleHelper.setGreyDataStyle(authorCell, styleContainer);
}

代码示例来源：origin: FenixEdu/fenixedu-academic

protected void addHeaderCell(HSSFSheet sheet, String value, int columnNumber) {
  HSSFRow row = sheet.getRow(0);
  if (row == null) {
    row = sheet.createRow(0);
  }
  HSSFCell cell = row.createCell(columnNumber);
  cell.setCellValue(value);
  cell.setCellStyle(headerStyle);
  cell.setCellValue(value);
  sheet.addMergedRegion(new CellRangeAddress(0, 1, columnNumber, columnNumber));
}

代码示例来源：origin: org.motechproject/motech-bulk-export-import

private void buildTitle(String title, int width) {
  HSSFRow rowTitle = sheet.createRow((short) currentRowIndex);
  rowTitle.setHeight((short) TITLE_ROW_HEIGHT);
  HSSFCell cellTitle = rowTitle.createCell(0);
  cellTitle.setCellValue(title);
  cellTitle.setCellStyle(new MotechCellStyle(sheet, CellStyle.ALIGN_CENTER).style());
  sheet.addMergedRegion(new CellRangeAddress(currentRowIndex, currentRowIndex, FIRST_COLUMN, width));
  currentRowIndex++;
}

代码示例来源：origin: qcadoo/mes

public void addMarginsAndStylesForAssignmentToShift(final HSSFSheet sheet, final int rowNumber, final int numberOfDays) {
  int margin = 3;
  int firstColumn = 0;
  int lastColumn = (numberOfDays + 1) * margin;
  for (int columnNumber = firstColumn; columnNumber <= lastColumn; columnNumber++) {
    if (sheet.getRow(rowNumber).getCell(columnNumber) == null) {
      sheet.getRow(rowNumber).createCell(columnNumber);
    }
    setWhiteDataStyleBorderBoxAlignCenterBold(sheet, sheet.getRow(rowNumber).getCell(columnNumber));
  }
  for (int columnNumber = 1; columnNumber <= lastColumn; columnNumber += margin) {
    sheet.addMergedRegion(new CellRangeAddress(rowNumber, rowNumber, columnNumber, columnNumber + 2));
  }
}

代码示例来源：origin: qcadoo/mes

public void addMarginsAndStylesForSeries(final HSSFSheet sheet, final int rowNumber, final int numberOfDays) {
  int margin = 3;
  int firstColumn = 0;
  int lastColumn = (numberOfDays + 1) * margin;
  for (int columnNumber = firstColumn; columnNumber <= lastColumn; columnNumber++) {
    if (sheet.getRow(rowNumber).getCell(columnNumber) == null) {
      sheet.getRow(rowNumber).createCell(columnNumber);
    }
    if (columnNumber == firstColumn) {
      setWhiteDataStyleBorderBoxAlignCenterBold(sheet, sheet.getRow(rowNumber).getCell(columnNumber));
    } else {
      setWhiteDataStyleBorderBoxAlignLeft(sheet, sheet.getRow(rowNumber).getCell(columnNumber));
    }
  }
  for (int columnNumber = 1; columnNumber <= lastColumn; columnNumber += margin) {
    sheet.addMergedRegion(new CellRangeAddress(rowNumber, rowNumber, columnNumber, columnNumber + 2));
  }
}