https://bz.apache.org/bugzilla/show_bug.cgi?id=59707
Bug ID: 59707 Summary: Create new line in cell doesn't work with BufferedReader Product: POI Version: 3.15-dev Hardware: PC Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: rbi...@ribics.fr Hi all, First of all, many thanks for this amazing library. I'm trying to create a new line in a cell by reading a file. I've implemented the sample https://poi.apache.org/spreadsheet/quick-guide.html#NewLinesInCells that works fine. I've modified the code in order to read an external file with the same content, and the \n is written in the file instead of having a new line. {code} public static void readTextFile() { BufferedReader br = null; ; try { br = new BufferedReader(new FileReader("C:/tmp/toto.txt")); String fileLine = ""; String excelFileName = "C:/tmp/Test.xlsx";// name of excel file String sheetName = "Sheet1";// name of sheet XSSFWorkbook wb = new XSSFWorkbook(); XSSFSheet sheet = wb.createSheet(sheetName); while ((fileLine = br.readLine()) != null) { System.out.println(fileLine); Row row = sheet.createRow(2); Cell cell = row.createCell(2); cell.setCellValue(fileLine); // to enable newlines you need set a cell styles with wrap=true CellStyle cs = wb.createCellStyle(); cs.setWrapText(true); cell.setCellStyle(cs); } FileOutputStream fileOut = new FileOutputStream(excelFileName); // write this workbook to an Outputstream. wb.write(fileOut); fileOut.flush(); fileOut.close(); br.close(); } catch (IOException ioe) { ioe.getMessage(); } } {code} My file contains only : Use \n with word wrap on to create a new line I've tried with new XSSFRichTextString(fileLine), but the \n is still present in the xlsx file. Do i miss something ? Is it a bug ? Thank you in advance for your replies and/or correction. Rich. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org