banner
RustyNail

RustyNail

coder. 【blog】https://rustynail.me 【nostr】wss://ts.relays.world/ wss://relays.world/nostr
HomeArchives

Poi export Excel line breaks are being eaten up.

34
AI Translation
This post is translated from Chinese into English through AI.View Original
AI-generated summary
When using easy poi to export an Excel file, there was an issue where some content was missing. The problem was solved by creating a cell style and applying it to the specific cells in the Excel file.

When exporting Excel using easy poi, \n is being eaten up.

Solution

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);
            }
Loading...
Ownership of this post data is guaranteed by blockchain and smart contracts to the creator alone.