Apache POI Merging Cells

by Online Tutorials Library July 14, 2022

Apache POI Merging Cells

Apache POI allows us to merge cells into a single cell. To do so, it provides methods which takes cell indexes as argument and merge the cells into a single large cell.

In the following example, we are creating two cells and merging them into a single cell. See the example.

Apache POI Merging Cells Example

  package poiexample;  import java.io.FileOutputStream;  import java.io.OutputStream;  import org.apache.poi.hssf.usermodel.HSSFWorkbook;  import org.apache.poi.ss.usermodel.Cell;  import org.apache.poi.ss.usermodel.Row;  import org.apache.poi.ss.usermodel.Sheet;  import org.apache.poi.ss.usermodel.Workbook;  import org.apache.poi.ss.util.CellRangeAddress;  public class MergingCellExample {  public static void main(String[] args) {      try (OutputStream fileOut = new FileOutputStream(“tutoraspire.xls”)) {      Workbook wb = new HSSFWorkbook();      Sheet sheet = wb.createSheet(“Sheet”);      Row row = sheet.createRow(1);      Cell cell = row.createCell(1);      cell.setCellValue(“Two cells have merged”);            //Merging cells by providing cell index      sheet.addMergedRegion(new CellRangeAddress(1,1,1,2));      wb.write(fileOut);      }catch(Exception e) {      System.out.println(e.getMessage());      }  }  }  

Output:

Apache POI Merging Cells

Next TopicApache POI Excel Font

Apache POI Merging Cells

Apache POI Merging Cells

Apache POI Merging Cells Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like