gaoluyang
3 天以前 0f4aa5957957d9124e88da4490fac60da5324058
yudao-framework/yudao-spring-boot-starter-excel/src/main/java/cn/iocoder/yudao/framework/excel/core/util/ExcelUtils.java
@@ -5,11 +5,14 @@
import cn.idev.excel.annotation.ExcelProperty;
import cn.idev.excel.context.AnalysisContext;
import cn.idev.excel.converters.longconverter.LongStringConverter;
import cn.idev.excel.enums.CellDataTypeEnum;
import cn.idev.excel.enums.CellExtraTypeEnum;
import cn.idev.excel.event.AnalysisEventListener;
import cn.idev.excel.metadata.CellExtra;
import cn.idev.excel.metadata.data.ReadCellData;
import cn.iocoder.yudao.framework.common.util.http.HttpUtils;
import cn.iocoder.yudao.framework.excel.core.handler.ColumnWidthMatchStyleStrategy;
import cn.iocoder.yudao.framework.excel.core.handler.RequiredHeaderWriteHandler;
import cn.iocoder.yudao.framework.excel.core.handler.SelectSheetWriteHandler;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.web.multipart.MultipartFile;
@@ -45,12 +48,13 @@
    public static <T> void write(HttpServletResponse response, String filename, String sheetName,
                                 Class<T> head, List<T> data) throws IOException {
        // 输出 Excel
        ExcelWriter excelWriter = FastExcelFactory.write(response.getOutputStream(), head)
        var builder = FastExcelFactory.write(response.getOutputStream(), head)
                .autoCloseStream(false) // 不要自动关闭,交给 Servlet 自己处理
                .registerWriteHandler(new ColumnWidthMatchStyleStrategy()) // 基于 column 长度,自动适配。最大 255 宽度
                .registerWriteHandler(new SelectSheetWriteHandler(head)) // 基于固定 sheet 实现下拉框
                .registerConverter(new LongStringConverter()) // 避免 Long 类型丢失精度
                .build();
                .registerConverter(new LongStringConverter()); // 避免 Long 类型丢失精度
        if (filename.contains("模板")) builder.registerWriteHandler(new RequiredHeaderWriteHandler());
        ExcelWriter excelWriter = builder.build();
        try {
            excelWriter.write(data, FastExcelFactory.writerSheet(sheetName).build());
        } finally {
@@ -67,12 +71,51 @@
    }
    public static <T> List<T> read(MultipartFile file, Class<T> head) throws IOException {
        AnalysisEventListener<T> headerNormalizeListener = new AnalysisEventListener<>() {
            @Override
            public void invokeHead(Map<Integer, ReadCellData<?>> headMap, AnalysisContext context) {
                normalizeHeadCells(headMap);
            }
            @Override
            public void invoke(T data, AnalysisContext context) {
            }
            @Override
            public void doAfterAllAnalysed(AnalysisContext context) {
            }
        };
        // 参考 https://t.zsxq.com/zM77F 帖子,增加 try 处理,兼容 windows 场景
        try (InputStream inputStream = file.getInputStream()) {
            return FastExcelFactory.read(inputStream, head, null)
            return FastExcelFactory.read(inputStream, head, headerNormalizeListener)
                    .autoCloseStream(false) // 不要自动关闭,交给 Servlet 自己处理
                    .doReadAllSync();
        }
    }
    /**
     * 去掉表头前面的必填星号。
     *
     * <p>导出模板时,{@link RequiredHeaderWriteHandler} 会给必填列的表头加上 "*" 前缀(如 "*部门名称"),
     * 而导入时 {@link ExcelProperty} 是按精确表头匹配的(如 "部门名称")。如果不去掉星号,
     * 整列都会绑定不上,字段全是 null,导入会报"系统异常"。
     *
     * <p>该方法在 {@code buildHead} 之前修改表头单元格的值,因此既兼容带星号的模板,
     * 也兼容用户手工去掉星号的文件。
     */
    private static void normalizeHeadCells(Map<Integer, ReadCellData<?>> headMap) {
        if (headMap == null) {
            return;
        }
        headMap.values().forEach(cellData -> {
            if (cellData == null || cellData.getType() != CellDataTypeEnum.STRING) {
                return;
            }
            String value = cellData.getStringValue();
            if (value != null && value.startsWith("*")) {
                cellData.setStringValue(value.substring(1).trim());
            }
        });
    }
    /**
@@ -147,6 +190,11 @@
        }
        @Override
        public void invokeHead(Map<Integer, ReadCellData<?>> headMap, AnalysisContext context) {
            normalizeHeadCells(headMap);
        }
        @Override
        public void invokeHeadMap(Map<Integer, String> headMap, AnalysisContext context) {
            sheetHeaderMap.put(context.readSheetHolder().getSheetNo(), headMap);
        }