[代码优化](v2.6)：修复导出 excel 数据报错

elunez · elunez · commit 76b600eeccc4 · 2020-12-12T22:54:07.000+08:00
close elunez#531
diff --git a/eladmin-common/src/main/java/me/zhengjie/utils/FileUtil.java b/eladmin-common/src/main/java/me/zhengjie/utils/FileUtil.java
@@ -248,7 +248,8 @@ private static void sizeChineseColumn(SXSSFSheet sheet, BigExcelWriter writer) {
                     SXSSFCell currentCell = currentRow.getCell(columnNum);
                     if (currentCell.getCellTypeEnum() == CellType.STRING) {
                         int length = currentCell.getStringCellValue().getBytes().length;
-                        if (columnWidth < length) {
+                        // 如果长度大于最大值 65280，那就取 length
+                        if (columnWidth < length || (columnWidth * 256 > 65280)) {
                             columnWidth = length;
                         }
                     }

Original file line number	Diff line number	Diff line change
`@@ -248,7 +248,8 @@ private static void sizeChineseColumn(SXSSFSheet sheet, BigExcelWriter writer) {`
`248`	`248`	`SXSSFCell currentCell = currentRow.getCell(columnNum);`
`249`	`249`	`if (currentCell.getCellTypeEnum() == CellType.STRING) {`
`250`	`250`	`int length = currentCell.getStringCellValue().getBytes().length;`
`251`		`- if (columnWidth < length) {`
	`251`	`+ // 如果长度大于最大值 65280，那就取 length`
	`252`	`+ if (columnWidth < length \|\| (columnWidth * 256 > 65280)) {`
`252`	`253`	`columnWidth = length;`
`253`	`254`	`}`
`254`	`255`	`}`