Quick code example on how to merge cells with POI and apply cell style to the merged cell.

Create cell

Workbook workbook = new HSSFWorkbook();
Sheet sheet = workbook.createSheet("new sheet");

Row row = sheet.createRow((short) 1);
row.setHeightInPoints(30); // set row height
sheet.setColumnWidth(1, 10*256); // set specific column width

Cell cell = row.createCell((short) 1);
cell.setCellValue("This is a string");

// cell.setCellType(Cell.CELL_TYPE_NUMERIC);
// cell.setCellValue(200);

Add merge region

CellRangeAddress mergedCell = new CellRangeAddress(
        1, //first row (0-based)
        1, //last row  (0-based)
        1, //first column (0-based)
        2  //last column  (0-based)
)
sheet.addMergedRegion(mergedCell);

Set merged region borders

RegionUtil.setBorderTop(CellStyle.BORDER_MEDIUM, mergedCell, sheet, workbook);
RegionUtil.setBorderBottom(CellStyle.BORDER_MEDIUM, mergedCell, sheet, workbook);
RegionUtil.setBorderLeft(CellStyle.BORDER_THIN, mergedCell, sheet, workbook);
RegionUtil.setBorderRight(CellStyle.BORDER_THIN, mergedCell, sheet, workbook);

Create cell style

CellStyle cellStyle = workbook.createCellStyle();

cellStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
cellStyle.setAlignment(CellStyle.ALIGN_CENTER);

Font cellFont = workbook.createFont();
cellFont.setBoldweight(Font.BOLDWEIGHT_NORMAL);
cellStyle.setFont(cellFont);

XSSFColor color = new XSSFColor(Color.WHITE);
// custom color with r, g, b
// XSSFColor color = new XSSFColor(new Color(146, 208, 80));
((XSSFCellStyle) cellStyle).setFillForegroundColor(color);
cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);

Set style

cell.setCellStyle(cellStyle);

References

BACK TO TOP
Post tagged with: poi, java