DengQN·一个普通程序员;
Poi 导出Excel换行被吃掉
2019-12-05 11:38 63
#导出#吃掉#解决#方法

用easy poi 导出excel的时候,\n被吃掉了

解决方法

Workbook workbook = ExcelExportUtil.exportExcel(params, map);
            CellStyle cs = workbook.createCellStyle();
            cs.setWrapText(true);
            for (int i = workbook.getSheetAt(0).getFirstRowNum() + 2; i <= workbook.getSheetAt(0).getLastRowNum(); i++) {
                Row row = workbook.getSheetAt(0).getRow(i);
                row.getCell(3).setCellStyle(cs);
            }