Multiline text in Excel cells
I found that you have to now include a third step after you follow the accepted answer to this question. You have to auto-size the column after you've added all of your data.
Assuming you're concerned about column 2,
sheet.autoSizeColumn(2);
See this example from Apache for context. It works for me with Java 8, poi-3.15.jar, and Excel for Mac.
You need to set the row height to accomodate two lines of text.
row.setHeightInPoints((2*sheet.getDefaultRowHeightInPoints()));
You need to set the wrap text = true
to get the new line.
Try this :
Here wb is the Workbook
.
CellStyle cs = wb.createCellStyle();
cs.setWrapText(true);
cell.setCellStyle(cs);