| | |
| | | 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; |
| | |
| | | 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 { |
| | |
| | | } |
| | | |
| | | 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()); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | /** |
| | |
| | | } |
| | | |
| | | @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); |
| | | } |