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);
}
将合并的每个单元格都设置了相同的样式,合并的单元格就是该样式。