Wiki
Clone wikiAspose for Apache POI / New-Line-in-Cells
Apache POI SS
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);
Aspose.Cells
// Add Text to the First Cell with Explicit Line Breaks cell.get(0, 0).setValue("I am using \nthe latest version of \nAspose.Cells \nto test this functionality"); //Get Cell's Style Style style = cell.get(0, 0).getStyle(); //Set Text Wrap property to true style.setTextWrapped(true); //Set Cell's Style cell.get(0, 0).setStyle(style);
Download Source Code
Updated