Aspose.Cells - New Line in 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);

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

Download Source Code

For More Examples, Please Visit Aspose Docs

Last edited Jan 29, 2015 at 9:23 AM by shoaibkhan, version 2