org.apache.poi.ss.usermodel.Sheet.addMergedRegion()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(7.6k)|赞(0)|评价(0)|浏览(569)

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

Sheet.addMergedRegion介绍

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

代码示例

代码示例来源：origin: alibaba/easyexcel

@Override
public void merge(int firstRow, int lastRow, int firstCol, int lastCol) {
  CellRangeAddress cra = new CellRangeAddress(firstRow, lastRow, firstCol, lastCol);
  context.getCurrentSheet().addMergedRegion(cra);
}

代码示例来源：origin: alibaba/easyexcel

private void addMergedRegionToCurrentSheet(int startRow) {
  for (com.alibaba.excel.metadata.CellRange cellRangeModel : excelHeadProperty.getCellRangeModels()) {
    currentSheet.addMergedRegion(new CellRangeAddress(cellRangeModel.getFirstRow() + startRow,
      cellRangeModel.getLastRow() + startRow,
      cellRangeModel.getFirstCol(), cellRangeModel.getLastCol()));
  }
}

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

sheet.addMergedRegion(region);

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

sheet.addMergedRegion(region);

代码示例来源：origin: looly/hutool

/**
 * 合并单元格，可以根据设置的值来合并行和列
 * 
 * @param sheet 表对象
 * @param firstRow 起始行，0开始
 * @param lastRow 结束行，0开始
 * @param firstColumn 起始列，0开始
 * @param lastColumn 结束列，0开始
 * @param cellStyle 单元格样式，只提取边框样式
 * @return 合并后的单元格号
 */
public static int mergingCells(Sheet sheet, int firstRow, int lastRow, int firstColumn, int lastColumn, CellStyle cellStyle) {
  final CellRangeAddress cellRangeAddress = new CellRangeAddress(//
      firstRow, // first row (0-based)
      lastRow, // last row (0-based)
      firstColumn, // first column (0-based)
      lastColumn // last column (0-based)
  );
  if (null != cellStyle) {
    RegionUtil.setBorderTop(cellStyle.getBorderTopEnum(), cellRangeAddress, sheet);
    RegionUtil.setBorderRight(cellStyle.getBorderRightEnum(), cellRangeAddress, sheet);
    RegionUtil.setBorderBottom(cellStyle.getBorderBottomEnum(), cellRangeAddress, sheet);
    RegionUtil.setBorderLeft(cellStyle.getBorderLeftEnum(), cellRangeAddress, sheet);
  }
  return sheet.addMergedRegion(cellRangeAddress);
}

代码示例来源：origin: looly/hutool

/**
 * 合并单元格，可以根据设置的值来合并行和列
 * 
 * @param sheet 表对象
 * @param firstRow 起始行，0开始
 * @param lastRow 结束行，0开始
 * @param firstColumn 起始列，0开始
 * @param lastColumn 结束列，0开始
 * @param cellStyle 单元格样式，只提取边框样式
 * @return 合并后的单元格号
 */
public static int mergingCells(Sheet sheet, int firstRow, int lastRow, int firstColumn, int lastColumn, CellStyle cellStyle) {
  final CellRangeAddress cellRangeAddress = new CellRangeAddress(//
      firstRow, // first row (0-based)
      lastRow, // last row (0-based)
      firstColumn, // first column (0-based)
      lastColumn // last column (0-based)
  );
  if (null != cellStyle) {
    RegionUtil.setBorderTop(cellStyle.getBorderTopEnum(), cellRangeAddress, sheet);
    RegionUtil.setBorderRight(cellStyle.getBorderRightEnum(), cellRangeAddress, sheet);
    RegionUtil.setBorderBottom(cellStyle.getBorderBottomEnum(), cellRangeAddress, sheet);
    RegionUtil.setBorderLeft(cellStyle.getBorderLeftEnum(), cellRangeAddress, sheet);
  }
  return sheet.addMergedRegion(cellRangeAddress);
}

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

Workbook wb = new HSSFWorkbook();
 Sheet sheet = wb.createSheet("new sheet");
 Row row = sheet.createRow((short) 1);
 Cell cell = row.createCell((short) 1);
 cell.setCellValue("This is a test of merging");
 sheet.addMergedRegion(new CellRangeAddress(
     1, //first row (0-based)
     1, //last row  (0-based)
     1, //first column (0-based)
     2  //last column  (0-based)
 ));
 // Write the output to a file
 FileOutputStream fileOut = new FileOutputStream("workbook.xls");
 wb.write(fileOut);
 fileOut.close();

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

XSSFWorkbook wb = new XSSFWorkbook();
CellStyle borderStyle = wb.createCellStyle();
borderStyle.setBorderBottom(CellStyle.BORDER_THIN);
borderStyle.setBorderLeft(CellStyle.BORDER_THIN);
borderStyle.setBorderRight(CellStyle.BORDER_THIN);
borderStyle.setBorderTop(CellStyle.BORDER_THIN);
borderStyle.setAlignment(CellStyle.ALIGN_CENTER);
Sheet sheet = wb.createSheet("Test Sheet");
Row row = sheet.createRow(1);
for (int i = 1; i <= 5; ++i) {
  Cell cell = row.createCell(i);
  cell.setCellStyle(borderStyle);
  if (i == 1) {
    cell.setCellValue("Centred Text");
  } 
}
sheet.addMergedRegion(new CellRangeAddress(1, 1, 1, 5));

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

private static void frame(CellRangeAddress region,Sheet sheet, Workbook wb){
  sheet.addMergedRegion(region);

  final short borderMediumDashed = CellStyle.BORDER_MEDIUM;
  RegionUtil.setBorderBottom(borderMediumDashed, region, sheet, wb);
  RegionUtil.setBorderTop(borderMediumDashed, region, sheet, wb);
  RegionUtil.setBorderLeft(borderMediumDashed, region, sheet, wb);
  RegionUtil.setBorderRight(borderMediumDashed, region, sheet, wb);
}

代码示例来源：origin: youseries/ureport

sheet.addMergedRegion(cellRegion);
sheet.addMergedRegion(cellRegion);

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

if (isNewMergedRegion(wrapper, mergedRegions)) {  
  mergedRegions.add(wrapper);  
  destSheet.addMergedRegion(wrapper.range);

代码示例来源：origin: youseries/ureport

sheet.addMergedRegion(cellRegion);

代码示例来源：origin: youseries/ureport

sheet.addMergedRegion(cellRegion);

代码示例来源：origin: cn.afterturn/easypoi-base

public static void addMergedRegion(Sheet sheet, int firstRow, int lastRow, int firstCol, int lastCol) {
  try {
    sheet.addMergedRegion(new CellRangeAddress(firstRow, lastRow, firstCol, lastCol));
  } catch (Exception e) {
    LOGGER.error("发生了一次合并单元格错误,{},{},{},{}", new Integer[]{
        firstRow, lastRow, firstCol, lastCol
    });
    // 忽略掉合并的错误,不打印异常
    LOGGER.debug(e.getMessage(), e);
  }
}

代码示例来源：origin: cn.bestwu.simpleframework/simpleframework-web

/**
 * @param firstRow 开始行
 * @param lastRow 结束行
 * @param firstCol 开始列
 * @param lastCol 结束列
 */
public void addMergedRegion(int firstRow, int lastRow, int firstCol, int lastCol) {
 sheet.addMergedRegion(new CellRangeAddress(firstRow, lastRow, firstCol, lastCol));
}

代码示例来源：origin: org.jeecg/easypoi-base

private void mergeRegion(int firstRow, int lastRow, int firstCol, int lastCol) {
    LOGGER.debug("Merge Region, From Row [{}], To [{}].", firstRow, lastRow);
    LOGGER.debug("From Col [{}], To [{}].", firstCol, lastCol);
    sheet.addMergedRegion(new CellRangeAddress(firstRow, lastRow, firstCol, lastCol));
  }
}

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

Workbook wb = new HSSFWorkbook();
Sheet sheet = wb.createSheet("Ageing Report");
Row row = sheet.createRow(1);
Cell cell = row.createCell(3);
cell.setCellValue("Aging Report on UN-acted (DETAILED)");
CellRangeAddress region = new CellRangeAddress(1, 1, 3, 4);
RegionUtil.setBorderBottom(CellStyle.BORDER_MEDIUM, region, sheet, wb);
RegionUtil.setBorderTop(CellStyle.BORDER_MEDIUM, region, sheet, wb);
RegionUtil.setBorderRight(CellStyle.BORDER_MEDIUM, region, sheet, wb);
RegionUtil.setBorderLeft(CellStyle.BORDER_MEDIUM, region, sheet, wb);
sheet.addMergedRegion(region);

代码示例来源：origin: biezhi/excel-plus

private void writeHeader(CellStyle cellStyle, Sheet sheet, String title, int maxColIndex) {
  Row titleRow = sheet.createRow(0);
  titleRow.setHeightInPoints(50);
  for (int i = 0; i <= maxColIndex; i++) {
    Cell cell = titleRow.createCell(i);
    if (i == 0) {
      cell.setCellValue(title);
    }
    cell.setCellStyle(cellStyle);
  }
  sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, maxColIndex));
}

代码示例来源：origin: hs-web/hsweb-expands

protected void startMerge() {
  prepareMerges();
  List<ExcelWriterConfig.Merge> merges = config.getMerges();
  for (ExcelWriterConfig.Merge merge : merges) {
    try {
      sheet.addMergedRegion(new CellRangeAddress(merge.getRowFrom() + config.getStartWith(), merge.getColTo() + config.getStartWith(), merge.getColFrom(), merge.getRowTo()));
    } catch (Exception e) {
      logger.error("merge column ({}) error", merge, e);
    }
  }
}

代码示例来源：origin: org.hswebframework/hsweb-expands-office

protected void startMerge() {
  prepareMerges();
  List<ExcelWriterConfig.Merge> merges = config.getMerges();
  for (ExcelWriterConfig.Merge merge : merges) {
    try {
      sheet.addMergedRegion(new CellRangeAddress(merge.getRowFrom() + config.getStartWith(), merge.getColTo() + config.getStartWith(), merge.getColFrom(), merge.getRowTo()));
    } catch (Exception e) {
      logger.error("merge column ({}) error", merge, e);
    }
  }
}

内容来源于网络，如有侵权，请联系作者删除！

sheet

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    Sheet类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com