XSSFWorkbook workbook = new XSSFWorkbook();XSSFSheet sheet = workbook.createSheet("Sheet");// 创建合并单元格区域CellRangeAddress mergedRegion = new CellRangeAddress(0, 0, 0, 5);sheet.addMergedRegion(mergedRegion);//创建单元格样式// 创建字体对象Font font = workbook.createFont();font.setFontName("PMingLiU");font.setFontHeightInPoints((short) 12);// 创建样式对象,并将字体应用于样式CellStyle style = workbook.createCellStyle();style.setFont(font);style.setVerticalAlignment(VerticalAlignment.TOP);// 设置边框样式style.setBorderTop(BorderStyle.THIN);style.setBorderBottom(BorderStyle.THIN);style.setBorderLeft(BorderStyle.THIN);style.setBorderRight(BorderStyle.THIN);XSSFRow row = sheet.createRow(0);XSSFCell cell = row.createCell(0);cell.setCellValue("Hello World");//循环合并的单元格,每个单元格都设置相同的样式for (int i = 0; i <= 5; i++) {XSSFCell cell1 = row.getCell(i);if (cell1 == null) {cell1 = row.createCell(i);}cell1.setCellStyle(style);}
将合并的每个单元格都设置了相同的样式,合并的单元格就是该样式。