jxls 单元格合并 1.0.6

依赖

<dependency>
    <groupId>net.sf.jxls</groupId>
    <artifactId>jxls-core</artifactId>
    <version>1.0.6</version>
</dependency>

关键方法

  Sheet sheet = workbook.getSheetAt(0);
  sheet.addMergedRegion(new CellRangeAddress(2, 4, 0, 0));

  // 可以自定义Merge对象, 设置fromRow, toRow
  sheet.addMergedRegion(new CellRangeAddress(merge.getFromRow(), merge.getToRow(), 0, 0));