alibaba/easyexcel

CellWriteHandler里设置千位符后需要在Excel中双击才显示

Open

#4.109 aberto em 17 de abr. de 2025

Ver no GitHub
 (0 comments) (0 reactions) (0 assignees)Java (7.599 forks)batch import
help wanted

Métricas do repositório

Stars
 (33.728 stars)
Métricas de merge de PR
 (Nenhuma PRs mesclada em 30d)

Description

异常代码

WriteCellStyle writeCellStyle = cellData.getOrCreateStyle(); // 字体策略 WriteFont contentWriteFont = new WriteFont(); // 字体大小 contentWriteFont.setFontHeightInPoints((short) 11); contentWriteFont.setFontName("微软雅黑"); writeCellStyle.setWriteFont(contentWriteFont); writeCellStyle.setBorderLeft(BorderStyle.THIN); writeCellStyle.setBorderRight(BorderStyle.THIN); writeCellStyle.setBorderTop(BorderStyle.THIN); writeCellStyle.setBorderBottom(BorderStyle.THIN); // 这里可以对cell进行任何操作 if (cell.getColumnIndex() > 0 && cell.getColumnIndex() > 3) { DataFormatData dataForma = new DataFormatData(); cellData.setType(CellDataTypeEnum.NUMBER); dataForma.setFormat("#,##0"); // 这个需要看模板,因为一个单元格会有多个 WriteCellData writeCellStyle.setHorizontalAlignment(HorizontalAlignment.RIGHT); writeCellStyle.setDataFormatData(dataForma); } 下载Excel后千位符的单元格没有生效,需要双击一下才能显示

Image

Guia do colaborador