Merge Cells

Aspose.Cells - Merge Cells

The Cells class has some useful methods for the task. For example, the merge method merges cells into a single cell within a specified range.

Java

 //Create a Workbook.
 Workbook wbk = new Workbook();

 //Create a Worksheet and get the first sheet.
 Worksheet worksheet = wbk.getWorksheets().get(0);

 //Create a Cells object to fetch all the cells.
 Cells cells = worksheet.getCells();

 //Merge some Cells (C6:E7) into a single C6 Cell.
 cells.merge(5,2,2,3);

 //Input data into the C6 cell.
 worksheet.getCells().get(5,2).setValue("This is a test of merging");

 //Save the Workbook.
 wbk.save(dataDir + "merge_Aspose.xls");

Apache POI SS - HSSF XSSF - Merge Cells

Sheet.addMergedRegion can be used to merge cells.

Java

 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)
 ));

Download Running Code

• GitHub

Download Sample Code

• GitHub

For more details, visit Merging and Unmerging (Splitting) Cells.