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后千位符的单元格没有生效，需要双击一下才能显示
