java poi 单元格换行符_java POI实现Excel单元格数据换行

Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook();

Sheet sheet = wb.createSheet();

Row row = sheet.createRow(2);

Cell cell = row.createCell(2);

cell.setCellValue("Use \n with word wrap on to create a new line");

//to enable newlines you need set a cell styles with wrap=true

CellStyle cs = wb.createCellStyle();

cs.setWrapText(true);

cell.setCellStyle(cs);

//increase row height to accomodate two lines of text

row.setHeightInPoints((2*sheet.getDefaultRowHeightInPoints()));

//adjust column width to fit the content

sheet.autoSizeColumn((short)2);

FileOutputStream fileOut = new FileOutputStream("E:\\standarcode\\ooxml-newlines.xlsx");

wb.write(fileOut);

fileOut.close();

效果：