CODEWITHSUNDEEP
javaapache-poi
Vicky
Vicky

Reputation: 17395

Merging cells in an excel output in POI

I am able to create the following excel using POI:

enter image description here

As clear from the image, each table is having two values viz. Val One and Val Two.

However, I want the Table Name two cells to be merged into one cell in the first column as below:

enter image description here

How to achieve this in POI ?

Upvotes: 10

Views: 29604

Answers (1)

shreyansh jogi
shreyansh jogi

Reputation: 2102

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

Upvotes: 19

Related Questions