20220902

xiaoyong931011

2022-09-26 cf23f00f49b69193945f6ea8c81d4737af539b61

 src/main/java/cc/mrbird/febs/common/utils/excl/ExcelUtil.java

@@ -224,7 +224,8 @@

    private static void buildSheetData(Workbook wb, Sheet sheet, ExcelSheetPO excelSheetPO, ExcelVersion version) {
        sheet.setDefaultRowHeight((short) 400);
        sheet.setDefaultColumnWidth((short) 10);
//        sheet.setDefaultColumnWidth((short) 10);
        sheet.autoSizeColumn(1);
        createTitle(sheet, excelSheetPO, wb, version);
        createHeader(sheet, excelSheetPO, wb, version);
        createBody(sheet, excelSheetPO, wb, version);
@@ -253,6 +254,10 @@
            Cell cellHeader = row.createCell(i);
            cellHeader.setCellStyle(getStyle(STYLE_HEADER, wb));
            cellHeader.setCellValue(headers[i]);
            // 调整每一列宽度
            sheet.autoSizeColumn((short) i);
            // 解决自动设置列宽中文失效的问题
            sheet.setColumnWidth(i, sheet.getColumnWidth(i) * 16 / 10);
        }

    }