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

效果：